Received: from c006.snv.cp.net (c006-h004.c006.snv.cp.net [209.228.33.160]) by postgresql.org (Postfix) with SMTP id C2D08474E4B for ; Wed, 27 Feb 2002 02:33:45 -0500 (EST) Received: (cpmta 20178 invoked from network); 26 Feb 2002 23:33:52 -0800 Date: 26 Feb 2002 23:33:52 -0800 Message-ID: <20020227073352.20177.cpmta@c006.snv.cp.net> X-Sent: 27 Feb 2002 07:33:52 GMT Received: from [66.108.148.98] by mail.ivillage.com with HTTP; 26 Feb 2002 23:33:51 PST Content-Type: text/plain Content-Disposition: inline Mime-Version: 1.0 To: pgsql-sql@postgresql.org From: otisg@ivillage.com X-Mailer: Web Mail 3.9.3.5 X-Sent-From: otisg@ivillage.com Subject: Err. compiling func. with SET TRANS... X-Archive-Number: 200202/423 X-Sequence-Number: 6844 Hello, I'm having trouble getting functions with SET TRANSACTION ISOLATION ... to parse. This is the error I'm getting (example function below the error): => select simple_fun(); NOTICE: plpgsql: ERROR during compile of simple_fun near line 3 ERROR: parse error at or near ";" This is the simple_fun function that is causing the above error: CREATE FUNCTION simple_fun() RETURNS INTEGER AS ' BEGIN SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; BEGIN; SELECT 1; END; RETURN 1; END; ' LANGUAGE 'plpgsql'; This is as simple as it gets. I think my syntax is correct (I checked Practical PostgreSQL book as well as a number of 7.2 PDF documents, etc.). Am I missing a secret ingredient here? Thank you, Otis _________________________________________________________________ iVillage.com: Solutions for Your Life Check out the most exciting women's community on the Web http://www.ivillage.com