Re: CREATE OR REPLACE VIEW/TRIGGER

2001-10-23 Thread Bruce Momjian
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

Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

2001-10-23 Thread Bruce Momjian
> > > 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

Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

2001-10-23 Thread Bill Studenmund
On Tue, 23 Oct 2001, Bruce Momjian wrote: > > Dear all, > > > > Would it be possible to implement CREATE OR REPLACE VIEW / TRIGGER in > > PostgreSQL 7.2? Probably not, it's rather late in the cycle (isn't beta imminent?). Oh, I'd vote for "OR REPLACE" as there's already an opt_or_replace non-ter

Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

2001-10-23 Thread Bruce Momjian
> 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 impl

Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

2001-10-23 Thread Bruce Momjian
> 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 Mo

Re: [HACKERS] CREATE OR REPLACE VIEW/TRIGGER

2001-10-23 Thread Tom Lane
Jean-Michel POURE <[EMAIL PROTECTED]> 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,

CREATE OR REPLACE VIEW/TRIGGER

2001-10-23 Thread Jean-Michel POURE
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 Postg