Re: Generated column and partitioning bug

Hi, Tom!

I will check version once more - I wrote that it latest version based on the thing, that yum does not pull any updates. Here is the command for main table and partitioned table:

p-# where attrelid = 'products_product_offers'::regclass and attnum > 0;
attname | attnum | attisdropped
-------------------------------+--------+--------------
id | 1 | f
shop_id | 2 | f
........pg.dropped.3........ | 3 | t
parent_id | 4 | f
........pg.dropped.5........ | 5 | t
currency_id | 6 | f
article | 7 | f
name | 8 | f
type | 9 | f
image | 10 | f
barcodes | 11 | f
sku | 12 | f
dimensions | 13 | f
weight | 14 | f
purchasingprice | 15 | f
price | 16 | f
state | 17 | f
created | 18 | f
updated | 19 | f
extid | 20 | f
raw | 21 | f
eav | 22 | f
doc | 23 | f
docupdated | 24 | f
parent_shop_id | 25 | f
items | 26 | f
docextended | 27 | f
........pg.dropped.28........ | 28 | t
inventoryupdated | 29 | f
........pg.dropped.30........ | 30 | t
........pg.dropped.31........ | 31 | t
virtual_shop_id | 32 | f
volume | 33 | f
(33 rows)

p=# select attname, attnum, attisdropped from pg_attribute
where attrelid = 'products_product_offers_shop_185456'::regclass and attnum > 0;
attname | attnum | attisdropped
-------------------------------+--------+--------------
id | 1 | f
shop_id | 2 | f
parent_id | 3 | f
currency_id | 4 | f
article | 5 | f
name | 6 | f
type | 7 | f
image | 8 | f
barcodes | 9 | f
sku | 10 | f
dimensions | 11 | f
weight | 12 | f
purchasingprice | 13 | f
price | 14 | f
state | 15 | f
created | 16 | f
updated | 17 | f
extid | 18 | f
raw | 19 | f
eav | 20 | f
doc | 21 | f
docupdated | 22 | f
parent_shop_id | 23 | f
items | 24 | f
docextended | 25 | f
inventoryupdated | 26 | f
........pg.dropped.27........ | 27 | t
virtual_shop_id | 28 | f
volume | 29 | f
(29 rows)

> 4 февр. 2022 г., в 20:04, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> написал(а):
>
> Maxim Gasumyants <m(at)gasumyants(dot)com> writes:
>> I am running latest release of PostgreSQL 12.
>
> Are you certain it's the latest? This looks suspiciously like
> some Var-numbering bugs we fixed a year or so ago.
>
> I failed to reproduce any problem in 12.9 on the basis of the
> info you supplied. I suppose that there might be some additional
> conditions needed, like a dropped column in the parent table,
> but experimentation didn't find it.
>
> It might be useful to show the results of
>
> select attname, attnum, attisdropped from pg_attribute
> where attrelid = 'products_product_offers'::regclass and attnum > 0;
>
> Also, if you can make a self-contained SQL script that exhibits
> the problem for you, that would be very useful.
>
> regards, tom lane