Re: Request for Comments: ALTER [OBJECT] SET SCHEMA

From: ziga(at)mail(dot)ljudmila(dot)org
To: "PostgreSQL-Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Request for Comments: ALTER [OBJECT] SET SCHEMA
Date: 2005-06-09 14:03:58
Message-ID: 52983.193.77.186.68.1118325838.squirrel@webmail.ljudmila.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

What about:

ALTER [OBJECT] RENAME TO [schema.]name [CASCADE]

This has somewhat less new syntax.
CASCADE would also move dependant objects.

Perhaps trigger functions should not be moved, since it
is not really obvious how to do this right.
Warning should be issued in this case.

Command basically frees user from having to hack system
castalogs; Is moving dependant object really such a big deal?
PostgreSQL does not really care where they are and just
keeps working - maybe this should be left up to DBA.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-06-09 14:06:34 Re: autovacuum in backend?
Previous Message Bernd Helmle 2005-06-09 13:19:29 Re: Request for Comments: ALTER [OBJECT] SET SCHEMA