Well, I guess that's the best solution: change the field name.
I hope to find some alternative solution, but I know it won't be easy.
Thank you.
Peter
-----Original Message-----
* Stephen Frost (sfrost@snowman.net)
The best solution would probably be to rename those fields in the 8.3
database, redo the dump, and then load it into 8.4. You could also use the
8.4 pg_dump to connect to and dump out the 8.3 database, but if you don't
change the identifiers, anything trying to use that database will fall over
if it doesn't quote the identifiers.
"window" in 8.4 is a reserved word, which it wasn't in 8.3.
Thanks,
Stephen
* Peter Lee (peter@flairpackaging.com) 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.
