"Guo, Yun" <YGuo@cvent.com> 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