| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| 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-15 18:14:06 |
| Message-ID: | 4C17C2EE.8080002@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2010-06-15 18:14:55 | Re: Is there a way to backup Postgres via SQL commands? |
| Previous Message | Greg Smith | 2010-06-15 18:07:57 | Re: Disk performance |