Re: CREATE OR REPLACE VIEW/TRIGGER - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: CREATE OR REPLACE VIEW/TRIGGER
Date
Msg-id 200110240455.f9O4tSw20630@candle.pha.pa.us
Whole thread Raw
In response to Re: CREATE OR REPLACE VIEW/TRIGGER  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Not until we do the necessary legwork.  I spent a good deal of time over
> the past week making the various PL modules react to replacement of
> pg_proc entries by CREATE OR REPLACE FUNCTION (cf. complaint from Peter
> a week or so back).  CREATE OR REPLACE VIEW implies updating cached
> query plans, and I'm not sure what CREATE OR REPLACE TRIGGER implies.
> But I am pretty sure it's not a trivial question.
>
> In short: put it on the todo list, but note that there are some
> implications...

That's all I needed to know.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-hackers by date:

Previous
From: Mike Mascari
Date:
Subject: Re: CREATE OR REPLACE VIEW/TRIGGER
Next
From: Tom Lane
Date:
Subject: Re: LOCK ROW SHARE MODE