Here's my current patch for ALTER OBJECT SET SCHEMA: the attached patch file implements schema "move" for FUNCTION, SEQUENCE, TYPE, DOMAIN and TABLE with all improvements discussed on -hackers recently. Altering OPERATOR, OPERATOR CLASS, AGGREGATE and CONVERSION are currently not implemented (since i ran out of time) :(

Supported syntax is

ALTER TABLE name SET SCHEMA name;
ALTER SEQUENCE name SET SCHEMA name;
ALTER FUNCTION name SET SCHEMA name;
ALTER TYPE name SET SCHEMA name;
ALTER DOMAIN name SET SCHEMA name;

TIA

--
 Bernd

Attachment: pgsql_alter.patch.bz2
Description: Binary data

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to