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

From: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
To: bashtanov(at)imap(dot)cc
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #11344: ALTER TABLE ... SET SCHEMA ... do not recurse to inherited tables
Date: 2014-09-03 12:50:09
Message-ID: CAJghg4J-FjFshofjY4+BpMo2Gvo5RRfJJGgw09S1_BdrvLq_9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Sep 3, 2014 at 9:35 AM, <bashtanov(at)imap(dot)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,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2014-09-03 16:07:55 Re: Re: [BUGS] Re: BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns
Previous Message Heikki Linnakangas 2014-09-03 12:45:43 Re: BUG #11344: ALTER TABLE ... SET SCHEMA ... do not recurse to inherited tables