Fix pg_dumpall to not query for filespace
This should create a dump that will work between 6.0 versions but
still needs ideas on how it would work for going to earlier versions
like 5.x.
@@ -1356,11 +1356,10 @@ dumpTablespaces(PGconn *conn)
{
res = executeQuery(conn, "SELECT spcname, "
"pg_catalog.pg_get_userbyid(spcowner) AS spcowner, "
- "fsname, spcacl, "
+ "spclocation, spcacl, "
"pg_catalog.shobj_description(t.oid, 'pg_tablespace') "
- "FROM pg_catalog.pg_tablespace t, "
- "pg_catalog.pg_filespace fs "
- "WHERE t.spcfsoid = fs.oid AND spcname !~ '^pg_' "
+ "FROM pg_catalog.pg_tablespace t "
+ "WHERE spcname !~ '^pg_' "
"ORDER BY 1");
}
