Thomas Kellerer <spam_eater@xxxxxxx> writes: > 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.) In principle we could reimplement pg_get_expr and sibling routines as code that just looks at the contents of the catalogs as they stood at the time of the surrounding query's snapshot. But that's not what they do today, and getting from point A to point B would be a lot of work. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
