Problem with too short column

From: Thomas(dot)AUBRY(at)limagrain(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem with too short column
Date: 2004-02-04 16:38:08
Message-ID: OFE4BCE870.D91C8E9B-ONC1256E30.005ACE95@ftgin.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I actually try to insert varchar which length is higher than 32 in a column
which type is varchar(32). I can't change the type of the column, and I
want to trunc the data. I know it's possible ! I have seen this !

Example : "j'aime les saucisses avec du beurre dedans" will be "j'aime les
saucisses avec du beu". For the moment it produces a SQL Error !

Is it an option in the config files ?

I'm using Postgresql 7.2.2.

Thanks in advance.

TOm

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Barnett-Cormack 2004-02-04 17:59:19 Re: hanging for 30sec when checkpointing
Previous Message Ugur Ileri 2004-02-04 16:33:11 Windows xp+PgSQL731wina1.exe