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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
