Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bill Studenmund <wrstuden(at)netbsd(dot)org>, Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>, pgsql-hackers(at)postgresql(dot)org, pgadmin-hackers(at)postgresql(dot)org, dpage(at)vale-housing(dot)co(dot)uk, peter_e(at)gmx(dot)net, lockhart(at)fourpalms(dot)org, Inoue(at)tpf(dot)co(dot)jp, oleg(at)sai(dot)msu(dot)su, scrappy(at)hub(dot)org
Subject: Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER
Date: 2001-10-24 04:55:28
Message-ID: 200110240455.f9O4tSw20630@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Mike Mascari 2001-10-24 05:13:43 Re: CREATE OR REPLACE VIEW/TRIGGER
Previous Message Tom Lane 2001-10-24 04:53:14 Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Mascari 2001-10-24 05:13:43 Re: CREATE OR REPLACE VIEW/TRIGGER
Previous Message Tom Lane 2001-10-24 04:53:14 Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER