BUG #11344: ALTER TABLE ... SET SCHEMA ... do not recurse to inherited tables

Поиск
Список
Период
Сортировка
От bashtanov@imap.cc
Тема BUG #11344: ALTER TABLE ... SET SCHEMA ... do not recurse to inherited tables
Дата
Msg-id 20140903123558.2924.6890@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #11344: ALTER TABLE ... SET SCHEMA ... do not recurse to inherited tables  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Re: BUG #11344: ALTER TABLE ... SET SCHEMA ... do not recurse to inherited tables  (Matheus de Oliveira <matioli.matheus@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      11344
Logged by:          Alexey Bashtanov
Email address:      bashtanov@imap.cc
PostgreSQL version: 9.3.4
Operating system:   CentOS Linux
Description:

Hello!

I perform the following actions
1) ALTER TABLE foo SET SCHEMA zzz
2) ALTER TABLE bar * SET SCHEMA zzz
and expect the tables inherited from foo and bar to be moved to schema zzz
as well as the master tables. My expectations are based on docs:
http://www.postgresql.org/docs/9.3/static/sql-altertable.html

However, only master tables are moved to zzz schema. Please fix either the
code or the docs.

Regards, Alexey Bashtanov

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

Предыдущее
От: Per Wigren
Дата:
Сообщение: PostgreSQL 9.2.9 segfault (backtrace included)
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #11344: ALTER TABLE ... SET SCHEMA ... do not recurse to inherited tables