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 solve this with the DB.

Anyway, thanks.

Bart

-----Ursprüngliche Nachricht-----
Von: Nigel J. Andrews [mailto:nandrews(at)investsystems(dot)co(dot)uk]
Gesendet: Freitag, 16. Mai 2003 14:04
An: Bartlomiej Frackiewicz
Cc: pgsql-general(at)postgresql(dot)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