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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
