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

From Bruce Momjian
Subject Re: CREATE OR REPLACE VIEW/TRIGGER
Date
Msg-id 200110240101.f9O117n29793@candle.pha.pa.us
Whole thread Raw
In response to CREATE OR REPLACE VIEW/TRIGGER  (Jean-Michel POURE <jm.poure@freesurf.fr>)
List pgsql-hackers
I have added this to the TODO list:

    * Add OR REPLACE clauses to non-FUNCTION object creation

I think there are clearly some other objects that need OR REPLACE.  Not
sure which ones yet.


---------------------------------------------------------------------------

> Dear all,
>
> Would it be possible to implement CREATE OR REPLACE VIEW / TRIGGER in
> PostgreSQL 7.2?
>
> Alternatively, could someone implement CREATE OR DROP VIEW / TRIGGER? These
> features are needed for pgAdmin II (we could also provide a patch for
> PhpPgAdmin). If this cannot be implemented in PostgreSQL, we will go for
> pseudo-modification solutions (which is definitely not a good solution).
>
> We are also waiting for a proper ALTER table DROP column but we are day
> dreamers...
>
> Thanks for your help and comprehension.
> Best regards,
> Jean-Michel POURE
> pgAdmin team
>

--
  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: David Eduardo Gomez Noguera
Date:
Subject: Re: Is there no "DESCRIBE ;" on PGSQL? help!!!
Next
From: bpalmer
Date:
Subject: Re: autoconf taking forever?