Re: Generated column and partitioning bug - Mailing list pgsql-bugs
From | Maxim Gasumyants |
---|---|
Subject | Re: Generated column and partitioning bug |
Date | |
Msg-id | E23AA8EE-8B5D-489B-B5FB-F010C89B8B9A@gasumyants.com Whole thread Raw |
In response to | Re: Generated column and partitioning bug (Tom Lane <tgl@sss.pgh.pa.us>) |
List | pgsql-bugs |
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@sss.pgh.pa.us> написал(а):Maxim Gasumyants <m@gasumyants.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
pgsql-bugs by date: