Not sure if this has been mentioned: any chance of doing it via a view?
Caveat: not sure when any form of length checking will take place.
Create a view, with an insert rule to perform the real insert into the
underlying table, and truncate in the rule function.
Regards!
Ed
On Fri, 16 May 2003, Bartlomiej Frackiewicz wrote:
> Hi,
>
> thanks for answering. Sure Perl can (handmade, DBI do not support this, or i am blindly), but i was in hope that i
cansolve this with the DB.
>
> Anyway, thanks.
>
> Bart
>
> -----Urspr�ngliche Nachricht-----
> Von: Nigel J. Andrews [mailto:nandrews@investsystems.co.uk]
> Gesendet: Freitag, 16. Mai 2003 14:04
> An: Bartlomiej Frackiewicz
> Cc: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] Rollback when value too long
>
>
> On Fri, 16 May 2003, Bartlomiej Frackiewicz wrote:
>
> > Hi,
> >
> > we are using "PostgreSQL 7.3.1 on i386-pc-linux-gnu" with Perl DBI.
> >
> > Some tables where directly updated from web forms, so when the input
> > is longer than the fileld, Postgres forces a rollback. This might be
> > right, but is very angry for me. Is there a way to teach Postgres
> > that it must truncate these values?
>
> No. Can't the perl code truncate them?
>
>
> --
> Nigel Andrews
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>