Re: [GENERAL] Removing a schema

2007-08-07 Thread Tom Lane
Naz Gassiep <[EMAIL PROTECTED]> writes: > I'm trying to remove a schema and move all the tables to another schema. > I've manually run alter table on every table to move them, however all > the foreign keys still reference the old schema, What? It works fine for me: regression=# create schema

Re: [GENERAL] Removing a schema

2007-08-07 Thread Nis Jørgensen
Naz Gassiep skrev: > I'm trying to remove a schema and move all the tables to another schema. > I've manually run alter table on every table to move them, however all > the foreign keys still reference the old schema, and there are too many > to do by hand. > > Is there an easy way to update one o

[GENERAL] Removing a schema

2007-08-06 Thread Naz Gassiep
I'm trying to remove a schema and move all the tables to another schema. I've manually run alter table on every table to move them, however all the foreign keys still reference the old schema, and there are too many to do by hand. Is there an easy way to update one of the system catalogs to do