Re: use window as field name in 8.4

[Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx>]

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 the 8.3 version of dump or the 8.4 version of dump. 8.4 added windowing functions which is likely the cause of your difficulty (i.e. a reserved word). The recommended procedure is to use the dump program from the newer version of PostgreSQL.

I also periodically review the reserved words at http://www.postgresql.org/docs/8.4/interactive/sql-keywords-appendix.html and (*ahem* try to) avoid using them as names for columns/tables/...

Cheers,
Steve