On Thu, Nov 3, 2011 at 11:56 PM, Michael Musenbrock wrote:
> But I have not
> found any information if this is possible to create a trigger on a
> constraint violation, and if yes, how could that be done?
You want to use the special type of "CONSTRAINT" trigger.
http://www.postgresql.org/docs/9
Hi,
I'm looking for a way to create a custom, for our application parsable,
error message on constraint violation.
The perfect thing would be, having table names, schemas and primary keys
in that error message.
My first thought was to create a function which gets triggered by the
constraint viola