Re: [GENERAL] syntax error at or near "PROCEDURAL"

2008-02-26 Thread Andreas Lau
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:[EMAIL PROTECTED] > Gesendet: Dienstag, 26. Februar 2008 10:30 > An: Andreas Lau; pgsql-general@postgresql.org

Re: [GENERAL] syntax error at or near "PROCEDURAL"

2008-02-26 Thread Andreas Lau
s Hagander [mailto:[EMAIL PROTECTED] 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 1

Re: [GENERAL] syntax error at or near "PROCEDURAL"

2008-02-26 Thread Magnus Hagander
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.

Re: [GENERAL] syntax error at or near "PROCEDURAL"

2008-02-26 Thread Martijn van Oosterhout
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 r

Re: [GENERAL] syntax error at or near "PROCEDURAL"

2008-02-26 Thread Magnus Hagander
On Mon, Feb 25, 2008 at 06:40:43PM +0100, Andreas Lau wrote: > Hello, > > I try to restore a dump file on a new Database. But unfortunatly i get this > error: > > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 532; 2612 16386 PROCEDUR

[GENERAL] syntax error at or near "PROCEDURAL"

2008-02-26 Thread Andreas Lau
Hello, I try to restore a dump file on a new Database. But unfortunatly i get this error: pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 532; 2612 16386 PROCEDURAL LANGUAGE plpgsql postgres pg_restore: [archiver (db)] could not execute