| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Geoffrey Wossum <geoffrey(at)pager(dot)net> |
| Cc: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Problems upgrading from 7.1.3 |
| Date: | 2003-02-06 16:26:00 |
| Message-ID: | 12882.1044548760@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Geoffrey Wossum <geoffrey(at)pager(dot)net> writes:
> Apparently PostgreSQL 7.1.3 didn't really enforce the length on VARCHAR(#)'s,
> which is why this never caused a problem with it.
Well, it did, but it did silent truncation instead of complaining.
This was determined to be not spec compliant ...
> Now, why did this all work fine if I added "-D" to pg_dump/pg_dumpall?
> Shouldn't that have failed for the same reason?
Yeah, it sure should have. Can you compare the two dumps to see what's
different besides the data proper?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gilbert | 2003-02-06 17:16:07 | Problems upgrading from 7.1.3 |
| Previous Message | Geoffrey Wossum | 2003-02-06 15:57:54 | Re: Problems upgrading from 7.1.3 |