Re: [PATCH] postgres_fdw extension support

On 2015-07-21 14:07:24 -0400, Tom Lane wrote:
> Paul Ramsey <pramsey@cleverelephant.ca> writes:
> > Folks are going to be OK w/ me dropping in new syscache entries so support my niche little feature?
> 
> No, mainly because it adds overhead without fixing your problem.

Meh. pg_extension updates are exceedingly rare, and there's a bunch of
code in extension.c that could very well have used a syscache instead of
doing manual scans over the table.

> It's not correct to suppose that a syscache on pg_extension would
> reliably report anything; consider ALTER EXTENSION ADD/DROP, which
> does not touch the pg_extension row.

I'd have just brute-force solved that by forcing a cache inval in that
case.


But I'm not going to complain too loudly if we don't do invalidation.

Andres