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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html