Skip site navigation (1) Skip section navigation (2)

Setting sqlstate in plpgsql function

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Setting sqlstate in plpgsql function
Date: 2007-04-06 17:26:33
Message-ID: 1d219a6f0704061026v4ee14b85n622cd27a0b53646d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Is where anyway to set the sqlstate to a custom value when inside a plpgsql
function?  I am still working on converting from Sybase ASA to Postgres and
some of the triggers and stored procedures in Sybase are setting the
variable to specific custom values.

Thanks,

Chris

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2007-04-06 17:45:28
Subject: Re: Setting sqlstate in plpgsql function
Previous:From: Joshua D. DrakeDate: 2007-04-06 16:26:57
Subject: Re: Database replication.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group