Re: attisdropped, * expansion and tg_trigtuple

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: attisdropped, * expansion and tg_trigtuple
Дата
Msg-id 8337.1056031206@sss.pgh.pa.us
обсуждение исходный текст
Ответ на attisdropped, * expansion and tg_trigtuple  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Ответы Re: attisdropped, * expansion and tg_trigtuple  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Список pgsql-general
"Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> If in a trigger one does a select * from the table the trigger is on
> is it safe to assume that tg_trigtuple (and so tg_newtuple) will use
> the same TupleDesc as that returned from the select *, i.e. the
> tg_relation->rd_att TupleDesc?

Given recent discussions about decoupling logical and physical column
order, I'd think that assumption might blow up in your face in a version
or two.  It's unsafe even today if the relation has dropped columns.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: explicit joins vs implicit joins
Следующее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: why are my SELECTs in transaction?