CREATE OR REPLACE VIEW/TRIGGER

Jean-Michel POURE <jm.poure@freesurf.fr> writes:

Would it be possible to implement CREATE OR REPLACE VIEW / TRIGGER in
PostgreSQL 7.2?

We're already vastly overdue for beta. The time for new feature
requests for 7.2 is past ... especially nontrivial requests.

regards, tom lane

We are also waiting for a proper ALTER table DROP column but we are day
dreamers...

This is a good example of bad management on our parts. We couldn't
decide between two possible DROP COLUMN implementations, so we now have
the worst result, which is no implementation at all.

-- 
  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

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).

Our current CREATE OR REPLACE FUNCTION perserves the OID of the
function. Is there similar functionality you need where a simple
DROP (ignore the error), CREATE will not work?

-- 
  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

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

On Tue, 23 Oct 2001 17:16:06 +0200, you wrote:

CREATE OR DROP VIEW

Is this for real? If I were a database server I would say to the
client "please make up your mind" :-)

Regards,
Ren� Pijlman <rene@lab.applinet.nl>

CREATE OR DROP VIEW

Is this for real? If I were a database server I would say to the
client "please make up your mind" :-)

I meant DROP IF EXISTS and then CREATE.
This is more simple to implement than CREATE OR REPLACE.

Best regards,
Jean-Michel POURE