Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 6 Apr 2007 13:26:33 -0400
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
- Follow-Ups:
- Re: Setting sqlstate in plpgsql function
- From: Tom Lane
- Re: Setting sqlstate in plpgsql function
- Prev by Date: Re: Database replication.
- Next by Date: Re: Setting sqlstate in plpgsql function
- Previous by thread: Database replication.
- Next by thread: Re: Setting sqlstate in plpgsql function
- Indexes: