From: | "Andreas Lau" <Andreas(dot)Lau(at)vaberlin(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: syntax error at or near "PROCEDURAL" |
Date: | 2008-02-26 09:44:27 |
Message-ID: | 49AA231E9907E940800FB4281B171F184C940E@v-x2003.vaberlin.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for your hinds.
It's true i used pg_dump and pg_restore version 8.3 to dump and restore 8.2 databases. I wouldn't have thought that there could be problems. But it seems so. I will give it a try an report the result.
Thanks Andreas
-----Ursprüngliche Nachricht-----
Von: Magnus Hagander [mailto:magnus(at)hagander(dot)net]
Gesendet: Dienstag, 26. Februar 2008 10:30
An: Andreas Lau; pgsql-general(at)postgresql(dot)org
Betreff: Re: [GENERAL] syntax error at or near "PROCEDURAL"
On Tue, Feb 26, 2008 at 10:26:25AM +0100, Martijn van Oosterhout wrote:
> On Tue, Feb 26, 2008 at 10:23:05AM +0100, Magnus Hagander wrote:
> > Any chance you are running pg_dump/pg_restore version 8.3? The
> > syntax appears to be what 8.3 uses, not 8.3..
> >
> > You can use (and should use) an 8.3 pg_dump to dump your 8.2
> > database when upgrading to 8.3, but you often can't reload a dump
> > created by 8.3 on an
> > 8.3 database.
>
> I think some of those 3's need to be 2's...
Argh. Yes. The last one in each paragraph. I blame fosdem-recovery ;-)
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2008-02-26 10:48:08 | Re: unnesesary sorting after Merge Full Join |
Previous Message | Stuart Brooks | 2008-02-26 09:41:04 | Re: autovacuum not freeing up unused space on 8.3.0 |