Postgres Pro
Downloads
Home   >   mailing lists

Finding tables dropped by DROP TABLE CASCADE - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Finding tables dropped by DROP TABLE CASCADE
Date
Msg-id 20110817.091032.1119726121414921164.t-ishii@sraoss.co.jp
Whole thread Raw
Responses Re: Finding tables dropped by DROP TABLE CASCADE
Re: Finding tables dropped by DROP TABLE CASCADE
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: synchronized snapshots
Next
From: Michael Paquier
Date:
Subject: Re: Finding tables dropped by DROP TABLE CASCADE