X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C950C475AF8 for ; Wed, 2 Apr 2003 01:03:06 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id E674347592C for ; Wed, 2 Apr 2003 01:03:05 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h326332L019017; Wed, 2 Apr 2003 01:03:03 -0500 (EST) To: Walter McGinnis Cc: pgsql-sql@postgresql.org Subject: Re: pesky plpgsql In-reply-to: References: Comments: In-reply-to Walter McGinnis message dated "Tue, 01 Apr 2003 20:37:03 -0800" Date: Wed, 02 Apr 2003 01:03:03 -0500 Message-ID: <19016.1049263383@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-32.5 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/19 X-Sequence-Number: 12720 Walter McGinnis writes: > When I call the function I get the following error: > devpps=# select update_cat_keys(); > NOTICE: plpgsql: ERROR during compile of update_cat_keys near line 2 > ERROR: parse error at or near ";" > The select in the loop runs fine in psql. So I'm stumped... Hmm, it looks fine to me too. What PG version is this? Could you provide the context (table creation commands, etc) so someone else could try to run the function? regards, tom lane