On Wed, 11 Feb 2004, Paulo Rogerio Zimolo wrote:
> I'm trying to do pg_dump an old version (7.3.4) to a new one (7.4.1) with
> the following command:
>
> pg_dump -U username -h server -i -o database | psql -U username -h
> newserver newdatabase
>
> As a result I got:
>
> pg_dump: server version:PostgreSQL 7.3.4 on i586-pc-linux-gnu, compiled
> by GCC 2.95.3;
> pg_dump version:7.2
It looks to me like the pg_dump you're using is even further out of date
by the above. I'd suggest trying to use the 7.4.1 pg_dump if you've got
it or at least the 7.3.4 one failing that.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
