Re: [GENERAL] Custom Constraint Violation Errors

2011-11-07 Thread Michael Musenbrock
Am 2011-11-07 16:06, schrieb 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

[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