Re: Problem with triggers - Mailing list pgsql-general

From Adrian von Bidder
Subject Re: Problem with triggers
Date
Msg-id 201006160656.32638@fortytwo.ch
Whole thread Raw
In response to Re: Problem with triggers  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Problem with triggers  (Sid <sid.the.technician@gmail.com>)
Re: Problem with triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Heyho!

On Wednesday 16 June 2010 00.56:14 Adrian Klaver wrote:
> > My question is: why do I get information about too long value before
> > trigger fires?
> > Can I change this behavior?

I firmly feel friendly error messages like this firmly beong into the
application and not into the DB.  Next thing you'll want translated messages
as well, and your triggers become so complex that you don't wnat to maintain
them ...

> The database is beating you to the validation.

With triggers.  A question to the experts: Couldn't this, in theory, be
implememnted within the rules system?  From what I understand they are run
right after the query is parsed; I'd expect data validation to come a bit
later.  Not sure if this is right.

cheers
-- vbi


--
Or is it?

Attachment

pgsql-general by date:

Previous
From: Anton Maksimenkov
Date:
Subject: consequent PQsendQueryPrepared() failed: another command is already in progress
Next
From: Greig Wise
Date:
Subject: Re: GSS Authentication