| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Peter Lee <peter(at)flairpackaging(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: use window as field name in 8.4 |
| Date: | 2010-06-19 01:03:10 |
| Message-ID: | 20100619010310.GC12697@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jun 15, 2010 at 08:58:52AM -0600, Peter Lee wrote:
> I am trying to upgrade our postgresql from 8.3 to 8.4.
>
> I found the "window" as field name makes many errors during
> pg_restore.
>
> - like "item.window".
>
> Is there any way I can restore the dump file from 8.3 without
> errors.
Use 8.4's pg_dump on the running 8.3 database, and your problem will
be fixed :)
Cheers,
David (oh, and pg_dump -Fc will let pg_restore, an enormously powerful
utility, do its magic).
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | M. Bashir Al-Noimi | 2010-06-19 05:07:23 | Re: Problem serving one-click installer to Syria |
| Previous Message | Vick Khera | 2010-06-18 20:19:47 | Re: rename table and triggers |