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

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

Responses

Browse pgsql-bugs by date

  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.