| From: | "Hartmut Goebel" <h(dot)goebel(at)goebel-consult(dot)de> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading |
| Date: | 2010-06-03 13:26:55 |
| Message-ID: | 201006031326.o53DQt56017667@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: 5488
Logged by: Hartmut Goebel
Email address: h(dot)goebel(at)goebel-consult(dot)de
PostgreSQL version: 8.3 / 8.4
Operating system: all
Description: pg_dump does not quote column names -> pg_restore may
fail when upgrading
Details:
If a 8.3 table contains a column named "window", the dump can not be
restored into a 8.4 database. Reasons: a) "window" is a new keyword in 8.4
b) pg_dump does not quote column names.
This is a generic problem with pg_dump. Since it does not quote all column
names, pg_restore may fail whenever migrating to a new version.
Solution: pg_dump should quote *all* column-names, no matter if they are
keywords or not.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-06-03 13:43:55 | Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading |
| Previous Message | Heikki Linnakangas | 2010-06-03 07:37:10 | Re: Server crash while trying to read expression using pg_get_expr() |