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
therecould 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@hagander.net]
Gesendet: Dienstag, 26. Februar 2008 10:30
An: Andreas Lau; pgsql-general@postgresql.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
