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

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