Postgres Pro
Downloads
Home   >   mailing lists

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  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Problem with too short column  (Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>)
Re: Problem with too short column  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-admin
Tree view 
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 ?