> 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-II since there's no API in PostgreSQL for that. Maybe I will look into the system catalog to find out children. I'm not sure if I can deal with CASCADE by the same method though. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
