Re: Rollback when value too long

Hi,

thanks for answering. Sure Perl can (handmade, DBI do not support this, or i am blindly), but i was in hope that i can
solvethis 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