Bizzare plpgsql error
От | Jim C. Nasby |
---|---|
Тема | Bizzare plpgsql error |
Дата | |
Msg-id | 20030527195600.GT40542@flake.decibel.org обсуждение исходный текст |
Ответы |
Re: Bizzare plpgsql error
|
Список | pgsql-general |
I'm getting this error trying to run a function: usps=# select process_zip4(); WARNING: Error occurred while executing PL/pgSQL function process_zip4 WARNING: line 55 at SQL statement ERROR: parser: parse error at or near "$1" at character 14 The relivant code is: IF z.record_type_code = ''P'' THEN INSERT INTO po_box SELECT z4.zip4_id , .... The INSERT INTO is line 55. What makes no sense is that it works fine if I change the name of the table from po_box to anything else. Any ideas? -- Jim C. Nasby (aka Decibel!) jim@nasby.net Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"
В списке pgsql-general по дате отправления: