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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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