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: (view raw, whole thread or download thread mbox)
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.




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-2018 The PostgreSQL Global Development Group