Postgres Pro
Downloads
Home   >   mailing lists

Truncation error - Mailing list pgsql-general

From terry@greatgulfhomes.com
Subject Truncation error
Date
Msg-id 000601c2229d$6c8a2d80$2766f30a@development.greatgulfhomes.com
Whole thread Raw
Responses Re: Truncation error
List pgsql-general
Tree view 
I upgraded to the new database, 7.2.1 from 7.0

Things are working good, except one bad hitch.  If I try to insert 75
characters into 60 character field I get:
ERROR: value too long for type character(60).

Is there a flag somewhere I can set to make the database go back to the old
behavior of blindly truncating the values upon insertion?

Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry@greatgulfhomes.com

pgsql-general by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: One source of constant annoyance identified
Next
From: Tom Lane
Date:
Subject: Re: One source of constant annoyance identified