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

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

The manual says:

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

It doesn't mention inherited tables at all. ?

- Heikki