pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: otisg@ivillage.com
To: pgsql-sql@postgresql.org
Subject: Err. compiling func. with SET TRANS...
Date: 26 Feb 2002 23:33:52 -0800
Message-ID: <20020227073352.20177.cpmta@c006.snv.cp.net> (raw)

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



view thread (3+ messages)  latest in thread

Message-ID: <20020227073352.20177.cpmta@c006.snv.cp.net>
Permalink:  ../20020227073352.20177.cpmta@c006.snv.cp.net/
Also on:    postgresql.org/message-id/20020227073352.20177.cpmta@c006.snv.cp.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: otisg@ivillage.com
  Subject: Re: Err. compiling func. with SET TRANS...
  In-Reply-To: <20020227073352.20177.cpmta@c006.snv.cp.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox