X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DABB7474E4F for ; Thu, 3 Apr 2003 13:55:08 -0500 (EST) Received: from europa.janwieck.net (h00045a2e4e7c.ne.client2.attbi.com [24.131.181.55]) by postgresql.org (Postfix) with ESMTP id 1BF6F474E44 for ; Thu, 3 Apr 2003 13:55:08 -0500 (EST) Received: from Yahoo.com (linksys.janwieck.net [192.168.192.1]) (authenticated) by europa.janwieck.net (8.11.6/8.11.6) with ESMTP id h33Isda08159; Thu, 3 Apr 2003 13:54:40 -0500 Message-ID: <3E8C834D.48B30572@Yahoo.com> Date: Thu, 03 Apr 2003 13:54:05 -0500 From: Jan Wieck Organization: Home X-Mailer: Mozilla 4.8 [en] (Windows NT 5.0; U) X-Accept-Language: en,ru MIME-Version: 1.0 To: Walter McGinnis Cc: pgsql-sql@postgresql.org Subject: Re: pesky plpgsql References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-28.5 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,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/48 X-Sequence-Number: 12749 Walter McGinnis wrote: > > Guess I'm an April Fool. When I define the following psql returns > "CREATE": > [...] > 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... > > I'm pretty ignorant about plpgsql, I'm used to pl/sql. What version of PostgreSQL and did you by any chance use a DOS editor (or anything that creates CRLF end of lines for that matter)? Older versions of PL/pgSQL didn't like that. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #