Yun Guo wrote:
> It doesn’t show up in custom format dump either… I begin to wonder if it’s
> a bug in pg_dump.
>
>
> -bash-4.1$ pg_dump -s -n test -Fc polling_etl | pg_restore -l | grep SCHEMA
> -bash-4.1$ pg_dump -s -n test2 -Fc polling_etl | pg_restore -l | grep
> SCHEMA
> 7; 2615 1131042 SCHEMA - test2 pb_writer
... or your database is corrupt.
Maybe it helps to issue the queries that pg_dump uses:
SELECT tableoid, oid, nspname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, nspacl FROM pg_namespace;
SELECT oid FROM pg_catalog.pg_namespace n WHERE (n.nspname = 'test');
Yours,
Laurenz Albe