| From: | bashtanov(at)imap(dot)cc |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #11344: ALTER TABLE ... SET SCHEMA ... do not recurse to inherited tables |
| Date: | 2014-09-03 12:35:58 |
| Message-ID: | 20140903123558.2924.6890@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 11344
Logged by: Alexey Bashtanov
Email address: bashtanov(at)imap(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2014-09-03 12:45:43 | Re: BUG #11344: ALTER TABLE ... SET SCHEMA ... do not recurse to inherited tables |
| Previous Message | Vik Fearing | 2014-09-03 12:05:50 | Re: [BUGS] BUG #10823: Better REINDEX syntax. |