On 08/16/2011 08:52 PM, Tatsuo Ishii wrote:
>> Presumably it would also need to invalidated if someone did ALTER
>> TABLE (which might recurse into unspecified children).
>
> Good point. For DROP TABLE/ALTER TABLE, I need to take care of its chidren.
>
>> It sort of seems like what you want to do
On Tue, Aug 16, 2011 at 8:52 PM, Tatsuo Ishii wrote:
>> Presumably it would also need to invalidated if someone did ALTER
>> TABLE (which might recurse into unspecified children).
>
> Good point. For DROP TABLE/ALTER TABLE, I need to take care of its chidren.
>
>> It sort of seems like what you wa
> Presumably it would also need to invalidated if someone did ALTER
> TABLE (which might recurse into unspecified children).
Good point. For DROP TABLE/ALTER TABLE, I need to take care of its chidren.
> It sort of seems like what you want to do is snoop the sinval traffic...
It's hard for pgpool
On Tue, Aug 16, 2011 at 8:10 PM, Tatsuo Ishii wrote:
> I'm working on implemeting query cache for pgpool-II. The query cache
> must be deleted if related tables are dropped. Finding tables oids
> from DROP TABLE t1, t2, t3... is easy. Problem is DROP TABLE
> CASCADE. It seems there's no easy way t
Just a suggestion, but...
Why not using an external wrapper function on reportDependentObjects in
dependency.c to find the list of Oids for a cascade deletion based on a list
of objects?
Isn't it possible?
Regards,
--
Michael Paquier
http://michael.otacoo.com
Hi,
I'm working on implemeting query cache for pgpool-II. The query cache
must be deleted if related tables are dropped. Finding tables oids
from DROP TABLE t1, t2, t3... is easy. Problem is DROP TABLE
CASCADE. It seems there's no easy way to find table oids which will be
deleted by DROP TABLE CAS