Re: [GENERAL] Custom Contraint Violation Errors

2011-11-07 Thread Richard Broersma
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

[GENERAL] Custom Contraint Violation Errors

2011-11-05 Thread Michael Musenbrock
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