pg_dumpall restore fails - Mailing list pgsql-bugs

Hi,

I'm trying to upgrade my server from Ubuntu Feisty to a later version and I think I've found a bug in pg_dumpall.  The version of Postgres from Feisty is not supported in later versions so I want to dump the DB and restore after upgrade.

On the server machine I have

• Postgres 7.4.13 running with my data in it.
• Postgres 8.3.1 (latest version available on Feisty).

On my test machine I have Postgres 8.3.5.

I tried to dump the 7.4.13 database using pg_dumpall from 8.3.1 and restore into 8.3.5 on my local test machine.  I get the following errors at restore time:

ERROR:  missing FROM-clause entry for table "icc_countries"
LINE 2: ...de, icc_members.county, icc_states.name AS state, icc_countr...
                                                             ^
ERROR:  relation "public.icc_members_test" does not exist
ERROR:  missing FROM-clause entry for table "icc_countries"
LINE 2: ...name AS state, icc_states.abbrev AS state_abbrev, icc_countr...
                                                             ^
ERROR:  relation "public.icc_members_with_admin" does not exist
ERROR:  missing FROM-clause entry for table "icc_countries"
LINE 2: ...de, icc_members.county, icc_states.name AS state, icc_countr...
                                                             ^
ERROR:  relation "public.icc_members_with_country" does not exist

It looks like pg_dumpall is generating malformed SQL for the dumped views.  I've attached the output from "pg_dumpall -c -s" as schema_dump.sql and the full output of that running psql 8.3.5 with that as input as psql_output.log.

Regards,

-Shaun