"Guo, Yun" <YGuo@xxxxxxxxx> writes: > It doesn¡¯t show up in custom format dump either¡¦ I begin to wonder if it¡¯s > a bug in pg_dump. pg_dump's handling of schemas is pretty darn simple; it's hard to see how it could "miss" a schema like that. It would be useful to see the output of these commands executed in the problematic database: SELECT oid FROM pg_catalog.pg_namespace n WHERE n.nspname ~ '^(test)$'; SELECT tableoid, oid, nspname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, nspacl FROM pg_catalog.pg_namespace; which are pretty much everything pg_dump issues that's directly related to dumping schemas. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
