Re: [GENERAL] use window as field name in 8.4

2010-06-18 Thread David Fetter
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.

Re: [GENERAL] use window as field name in 8.4

2010-06-15 Thread Peter Lee
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 (sfr...@snowman.net) The best solution would probably be to rename those fields in the 8.3 database,

Re: [GENERAL] use window as field name in 8.4

2010-06-15 Thread Steve Crawford
On 06/15/2010 07:58 AM, 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. Peter Does this happen using

Re: [GENERAL] use window as field name in 8.4

2010-06-15 Thread Stephen Frost
* Peter Lee (pe...@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. The best solutio

[GENERAL] use window as field name in 8.4

2010-06-15 Thread Peter Lee
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. Peter