| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
| Cc: | "Mitch Vincent" <mitch(at)venux(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] Reasonable |
| Date: | 1999-10-05 23:10:10 |
| Message-ID: | 12586.939165010@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> writes:
> Another potential problem is your use of a six-letter long default for a
> varying(1) field ("status").
6.5.* has some problems with wrong-length default values for char(n) and
varchar(n) fields. There is a slightly klugy fix in place for char(n),
but a cursory test suggests that it doesn't catch the varchar case.
The consequences aren't as bad as they were for char(n): you just get
a field value that's longer than it's supposed to be. Workaround:
give a correct default value.
This is all fixed properly in current sources (6.6/7.0-to-be).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Bondarenko | 1999-10-06 06:38:33 | Re: [SQL] 2 Aktions in a Rule |
| Previous Message | Howie | 1999-10-05 19:09:44 | Re: [SQL] 2 Aktions in a Rule |