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 по дате отправления:

Предыдущее
От: Adam Sherman
Дата:
Сообщение: Re: Locating all Children given Set of Parents
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Locating all Children given Set of Parents