Hello! The following SQL works:
ALTER TABLE a.foo RENAME TO bar; But the following doesn't: ALTER TABLE a.foo RENAME TO b.bar; The capability to move objects to other schemas would be quite useful. Apparently, everything works OK if you change pg_class.relnamespace with UPDATE, but this is not very nice. Are there any problems to be expected with this that I am missing and if not, would it make sense to support changing schemas with ALTER TABLE? ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly