Skip site navigation (1) Skip section navigation (2)

Bizzare plpgsql error

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Bizzare plpgsql error
Date: 2003-05-27 19:56:00
Message-ID: 20030527195600.GT40542@flake.decibel.org (view raw or flat)
Thread:
Lists: 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(at)nasby(dot)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?"

Responses

pgsql-general by date

Next:From: scott.marloweDate: 2003-05-27 20:08:12
Subject: Re: Postgresql on SUN Server
Previous:From: Alvaro HerreraDate: 2003-05-27 19:48:07
Subject: Re: newbie sql question...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group