Re: before trigger doesn't, on insert of too long data

From: Neil Conway <neilc(at)samurai(dot)com>
To: Thomas Erskine <thomas(dot)erskine(at)sympatico(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org, Anil Nair <anil(at)talentmap(dot)com>
Subject: Re: before trigger doesn't, on insert of too long data
Date: 2003-11-10 19:35:09
Message-ID: 871xsgyq36.fsf@mailbox.samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thomas Erskine <thomas(dot)erskine(at)sympatico(dot)ca> writes:
> A before trigger doesn't always fire. If a column being inserted into is
> too small for the incoming data, psql complains:
> ERROR: value too long for type ...
> without giving the trigger procedure a chance to deal with it.

I believe this is a feature, not a bug: a CHAR(4) field should never,
ever contain > 4 characters. Whether there is a trigger that is yet to
be processed is not relevant.

I'd suggest changing the type of the column to be TEXT, or similar
(which should be just as efficient CHAR(4)).

-Neil

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Neil Conway 2003-11-10 19:37:51 Re: COPY and sequences
Previous Message Gaetano Mendola 2003-11-10 00:24:46 Re: Autocomplete <TAB> on Postgres7.4beta5 not working?