Re: partitioning and identity column

Hello Ashutosh,

26.04.2024 21:00, Alexander Lakhin wrote:
> 26.04.2024 15:57, Ashutosh Bapat wrote:
>> Thanks Alexander for the report.
>>
>> On Fri, Apr 26, 2024 at 5:30 PM Alexander Lakhin <exclusion(at)gmail(dot)com> wrote:
>>
>>
>> CREATE TABLE tbl3 (LIKE tbl2 INCLUDING IDENTITY);
>> ERROR:  no owned sequence found
>>
>>
>
>>
>> Do you want to track this in open items?
>>
>
> If you are inclined to fix this behavior,  I would add this item.

Please look also at another script, which produces the same error:
CREATE TABLE tbl1 (a int GENERATED BY DEFAULT AS IDENTITY, b text)
   PARTITION BY LIST (b);
CREATE TABLE tbl2 PARTITION OF tbl1 DEFAULT;

ALTER TABLE tbl1 ALTER COLUMN a SET DATA TYPE bigint;
ERROR:  no owned sequence found

(On 699586315~1, it executes successfully and changes the data type of the
identity column and it's sequence.)

Best regards,
Alexander