Re: BUG #15238: Sequence owner not updated when owning table is foreign

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: christoph(dot)berg(at)credativ(dot)de, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15238: Sequence owner not updated when owning table is foreign
Date: 2018-06-15 03:40:01
Message-ID: 20180615034001.lgsbilj7pqczofj7@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2018-Jun-14, Peter Eisentraut wrote:

> Also, can partitioned tables have serial columns? Are there more omissions?

You're right, this is wrong for partitioned tables too.

create table part (a serial) partition by range (a);
create table part2 partition of part for values from (1) to (1000);
create user foo;
alter table part owner to foo;

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2018-06-15 03:59:04 Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression"
Previous Message Peter Eisentraut 2018-06-15 03:29:19 Re: BUG #15238: Sequence owner not updated when owning table is foreign