Re: CREATE OR REPLACE VIEW/TRIGGER

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
Cc: 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, wrstuden(at)netbsd(dot)org, oleg(at)sai(dot)msu(dot)su, scrappy(at)hub(dot)org
Subject: Re: CREATE OR REPLACE VIEW/TRIGGER
Date: 2001-10-24 01:01:07
Message-ID: 200110240101.f9O117n29793@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers 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(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 Tom Lane 2001-10-24 04:53:14 Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER
Previous Message Bruce Momjian 2001-10-24 00:56:57 Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

Browse pgsql-hackers by date

  From Date Subject
Next Message David Eduardo Gomez Noguera 2001-10-24 01:36:50 Re: Is there no "DESCRIBE <TABLE>;" on PGSQL? help!!!
Previous Message Bruce Momjian 2001-10-24 00:56:57 Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER