Horton

Re: erroneous restore into pg_catalog schema

Dimitri Fontaine <dimitri@2ndquadrant.fr>

View thread View on postgr.es
From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: "Erik Rijkers" <er@xs4all.nl>
Cc: pgsql-hackers@postgresql.org
Date: 2013-01-13T15:53:30Z
Lists: pgsql-hackers 
"Erik Rijkers" <er@xs4all.nl> writes:
> (and yes, I did restore a 65 GB table into the pg_catalog schema of a dev machine; how can I
> remove it? I could initdb, but it's 200+ GB; I'd rather not have to rebuild it)

See allow_system_table_mods

  http://www.postgresql.org/docs/9.2/static/runtime-config-developer.html

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

Commits

  1. Extend and improve use of EXTRA_REGRESS_OPTS.

  2. Remove misplaced sanity check from heap_create().

  3. Silently ignore any nonexistent schemas that are listed in search_path.