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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.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