| From: | "Gene Neely" <paul(dot)neely(at)comcast(dot)net> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2643: Auto trim on insert and update |
| Date: | 2006-09-21 17:02:19 |
| Message-ID: | 200609211702.k8LH2JRr067510@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2643
Logged by: Gene Neely
Email address: paul(dot)neely(at)comcast(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-09-21 17:04:21 | Re: BUG #2642: Connection problems without IPv6 |
| Previous Message | Christoph Zwerschke | 2006-09-21 16:49:26 | BUG #2642: Connection problems without IPv6 |