BUG #2643: Auto trim on insert and update - Mailing list pgsql-bugs

From Gene Neely
Subject BUG #2643: Auto trim on insert and update
Date
Msg-id 200609211702.k8LH2JRr067510@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #2643: Auto trim on insert and update
List pgsql-bugs
The following bug has been logged online:

Bug reference:      2643
Logged by:          Gene Neely
Email address:      paul.neely@comcast.net
PostgreSQL version: 8.0.x 8.1.x
Operating system:   Linux
Description:        Auto trim on insert and update
Details:

THIS IS NOT A BUG, but a request. Found no place else to submit.
I have found no way to automatically trim fields to the length of the
varchar or char on inserts and updates.
I have tried to create check rules to trim to the varchar length with not
luck.
Can this become a Configuration option???
Doing trims of every variable at every sql command execution takes a lot of
time both coding and lookup the columns length.
Thanks.
Gene Neely

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Out of memory error during large hashagg
Next
From: "Massimiliano Citterio"
Date:
Subject: BUG #2644: pgadmin III foreign key