Re: syntax error at or near "PROCEDURAL"

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