RE: drop table and pg_proc

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: RE: drop table and pg_proc
Date: 2001-01-11 19:16:11
Message-ID: 8F4C99C66D04D4118F580090272A7A234D325E@sectorbase1.sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> This is just one instance of the generic problem that we don't enforce
> referential integrity across system catalogs. Since this issue has

Wouldn't be easy to do for views (rules) anyway - table oids are somewhere
in the body of rule, they are not just keys in column. Also, triggers are
handled by Executor and we don't use it for DDL statements. I think it's ok,
we have just add "isdurty" column to some tables (to be setted when some of
refferenced objects deleted/altered and to be used as flag that
"re-compiling"
is required) and new table to remember object relationships.

Guys here, in Sectorbase, blames PostgreSQL a much for this thing -:)
They are Oracle developers and development under PostgreSQL makes
them quite unhappy. Probably, work in this area will be sponsored
by my employer (with me as superviser and some guys in Russia as
developers), we'll see.

Vadim

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2001-01-11 19:16:57 RE: AW: Re: GiST for 7.1 !!
Previous Message Jeff Davis 2001-01-11 18:48:36 alter table drop column