Problem with too short column - Mailing list pgsql-admin

From Thomas.AUBRY@limagrain.com
Subject Problem with too short column
Date
Msg-id OFE4BCE870.D91C8E9B-ONC1256E30.005ACE95@ftgin.net
Whole thread Raw
Responses Re: Problem with too short column
Re: Problem with too short column
Re: Problem with too short column
List 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



pgsql-admin by date:

Previous
From: neelesh vijaivargia
Date:
Subject: Data location in PostgreSQL
Next
From: Frédéric Médery
Date:
Subject: List all users rights ?