Ok, how do I debug THIS?
От | Larry Rosenman |
---|---|
Тема | Ok, how do I debug THIS? |
Дата | |
Msg-id | 246160000.1052853868@lerlaptop.iadfw.net обсуждение исходный текст |
Ответы |
Re: Ok, how do I debug THIS?
|
Список | pgsql-sql |
I'm getting: ERROR: parse error at or near "IF" WARNING: plpgsql: ERROR during compile of networks_trigger_log near line 206 $ but the function is: $ wc -l z 147 z $ head z CREATE OR REPLACE FUNCTION networks_trigger_log () RETURNS "trigger" AS 'DECLARE record_fields_old text; record_values_oldtext; record_fields_new text; record_values_new text; query_string_old text; query_string_new text; BEGIN query_string_old := ''INSERT INTO networks_log''; $ How do I find my stupidity? $ psql Welcome to psql 7.3.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit ler=# select version(); version ---------------------------------------------------------------------PostgreSQL 7.3.2 on i386-portbld-freebsd4.7, compiledby GCC 2.95.4 (1 row) ler=# -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
В списке pgsql-sql по дате отправления: