Finding tables dropped by DROP TABLE CASCADE

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Finding tables dropped by DROP TABLE CASCADE
Date: 2011-08-17 00:10:32
Message-ID: 20110817.091032.1119726121414921164.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 CASCADE. Any idea?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2011-08-17 00:19:46 Re: Finding tables dropped by DROP TABLE CASCADE
Previous Message Jim Nasby 2011-08-16 22:53:43 Re: synchronized snapshots