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

Поиск
Список
Период
Сортировка
От ziga@mail.ljudmila.org
Тема Re: Request for Comments: ALTER [OBJECT] SET SCHEMA
Дата
Msg-id 52983.193.77.186.68.1118325838.squirrel@webmail.ljudmila.org
обсуждение исходный текст
Ответ на Re: Request for Comments: ALTER [OBJECT] SET SCHEMA  (Bernd Helmle <mailings@oopsware.de>)
Список 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.




В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Arshad Mahmood"
Дата:
Сообщение: Building WIN32 DLL's
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: [GENERAL] mirroring oracle database in pgsql