Re: pg_get_expr() hangs with uncommitted DDL transaction

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_get_expr() hangs with uncommitted DDL transaction
Date: 2014-11-11 16:42:47
Message-ID: m3tea7$4ml$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert DiFalco 2014-11-11 22:38:16 Modeling Friendship Relationships
Previous Message Tom Lane 2014-11-11 16:08:46 Re: pg_get_expr() hangs with uncommitted DDL transaction