CREATE OR REPLACE VIEW / TRIGGER

Поиск
Список
Период
Сортировка
Искать

CREATE OR REPLACE VIEW / TRIGGER

От:
Jean-Michel POURE <jm.poure@freesurf.fr>
Дата:
Dear community, dear friends,

I know it is feature freeze, so forgive me for this (ancien) question : would 
it possible to add CREATE OR REPLACE VIEW and CREATE OR REPLACE TRIGGER in 
current PostgreSQL 7.2 release? Otherwise, it will take another year before 
these long-needed features are added.

Is this really a difficult hack? 

If not possible, we will be obliged to hack pgAdmin II to add virtual create 
/ drop statements. And hack it back when the features are added natively to 
PostgreSQL. This is not the way we should do it.

Please help :)

There can be up to 4000 download of pgAdmin a month. If pgAdmin II were 
published on public download sites, possibly bundled with a Cygwin PostgreSQL 
installer, the number could easily reach 10.000 a month. Maybe more.

So please consider CREATE OR REPLACE VIEW / TRIGGER are important features 
for 7.2, not 7.3.

Best regards,
Jean-Michel POURE

Re: CREATE OR REPLACE VIEW / TRIGGER

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Jean-Michel POURE  writes:
> I know it is feature freeze, so forgive me for this (ancien) question : would
> it possible to add CREATE OR REPLACE VIEW and CREATE OR REPLACE TRIGGER in 
> current PostgreSQL 7.2 release?

No.  RC1 is *tomorrow*, and we're not pushing it back to add features.

> Otherwise, it will take another year before 
> these long-needed features are added.

I'd like to ask people not to adopt the mindset that PG releases are a
year apart.  I know it's been that way for the last two, but the project
goals are still to have a release every four-to-six months.  If we go
into the development cycle with the notion that the next release is a
year out, it will be a self-fulfilling prophecy.

			regards, tom lane
FAQ