Postgres Pro
Downloads
Home   >   mailing lists

Re: Trouble with Savepoints in postgres - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Trouble with Savepoints in postgres
Date
Msg-id 20080311213910.GB6737@alvh.no-ip.org
Whole thread Raw
In response to Trouble with Savepoints in postgres  (sam <sam.mahindrakar@gmail.com>)
List pgsql-general
Tree view 
sam escribió:

> Iam not able to understand if this is a version problem or the way iam
> using savepoints is wrong.Please advice.

It is.  You cannot use savepoints in PL/pgSQL functions (or any function
for that matter).  You can use EXCEPTION clauses instead.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: How to convert postgres timestamp to date: yyyy-mm-dd
Next
From: "Tri Quach"
Date:
Subject: Re: Relocation error: /usr/lib/libpq.so.5: undefinedsymbol: krb5_cc_get_principal