Re: [BUGS] BUG #14521: pg_attribute.attndims = 0 for array column

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14521: pg_attribute.attndims = 0 for array column
Дата
Msg-id 3792.1485959113@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [BUGS] BUG #14521: pg_attribute.attndims = 0 for array column  (krzysztof.heim@gmail.com)
Список pgsql-bugs
krzysztof.heim@gmail.com writes:
> I have base table A with column type integer array.
> I also have table B derived from table A.

> When I query pg_attribute for table A, attndims shows 1 (correct), when I do
> same query for table B - attndims shows 0 for same column.

> Is it a bug, or it's desired behavior (since it's a derived column).

We don't really care.  attndims is a historical leftover and should never
be relied on for any semantically significant purpose.

TBH, my inclination would be to remove the column altogether rather than
"fix" this.

            regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: krzysztof.heim@gmail.com
Дата:
Сообщение: [BUGS] BUG #14521: pg_attribute.attndims = 0 for array column
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14521: pg_attribute.attndims = 0 for array column