Re: BUG #11344: ALTER TABLE ... SET SCHEMA ... do not recurse to inherited tables - Mailing list pgsql-bugs

On Wed, Sep 3, 2014 at 9:35 AM, <bashtanov@imap.cc> wrote:

>  1) ALTER TABLE foo SET SCHEMA zzz
> 2) ALTER TABLE bar * SET SCHEMA zzz
>


I think one confusion is that the command (2) and:

    ALTER TABLE ONLY baz SET SCHEMA zzz;

are accepted. If SET SCHEMA does nothing about inherited table, why does it
accept ONLY and "*" ? Which are not accepted syntax from the docs.

Regards,
--=20
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br n=C3=ADvel F!
www.dextra.com.br/postgres