Re: pg_get_expr() hangs with uncommitted DDL transaction

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: pg_get_expr() hangs with uncommitted DDL transaction
Дата
Msg-id m3tea7$4ml$1@ger.gmane.org
обсуждение исходный текст
Ответ на Re: pg_get_expr() hangs with uncommitted DDL transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane schrieb am 11.11.2014 um 17:08:
>> Does this mean that pg_get_expr() selects additional data from the table,
>> instead of just using the values that are provided by the caller?
>
> No, it means it depends on backend code that is also used when accessing
> the table "for real", and that code doesn't work safely without a lock.
> (In particular, a lot of what ruleutils.c does ultimately reduces to
> catalog cache lookups, and we can *not* allow stale data in those caches.)

Ah! Understood. Thanks for the explanation.

Thomas



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_get_expr() hangs with uncommitted DDL transaction
Следующее
От: Robert DiFalco
Дата:
Сообщение: Modeling Friendship Relationships