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

On 09/03/2014 03:35 PM, bashtanov@imap.cc wrote:
> 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.

The manual says:

>
> SET SCHEMA
>
>     This form moves the table into another schema. Associated indexes, constraints, and sequences owned by table
columnsare moved as well. 

It doesn't mention inherited tables at all.  ?

- Heikki