Re: pg_get_expr() hangs with uncommitted DDL transaction - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: pg_get_expr() hangs with uncommitted DDL transaction
Date
Msg-id m3tea7$4ml$1@ger.gmane.org
Whole thread Raw
In response to Re: pg_get_expr() hangs with uncommitted DDL transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_get_expr() hangs with uncommitted DDL transaction
Next
From: Robert DiFalco
Date:
Subject: Modeling Friendship Relationships