Re: CREATE OR REPLACE TRIGGER

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Sent: 13 August 2002 10:26
> To: Tom Lane; Dave Page
> Cc: Gavin Sherry; pgsql-patches(at)postgresql(dot)org
> Subject: Re: [PATCHES] CREATE OR REPLACE TRIGGER
>
>
> Le Dimanche 11 Août 2002 21:26, Tom Lane a écrit :
> > So implement it as DROP TRIGGER/CREATE TRIGGER. There's no
> need for
> > the backend to provide a special case shortcut...
>
> Please implement DROP/CREATE in the backend. Users do not
> understand that
> objects cannot be modified. We all want this feature. We are
> starving for
> it...

Hi Jean-Michel,

Whilst I would rather see this feature in PostgreSQL itself, Tom is right, in this case because nothing is ever dependant on a trigger, a DROP/CREATE in pgAdmin would be relatively easy to implement.

At least we should have CREATE OR REPLACE VIEW|RULE which are much harder to do at our end.

Regards, Dave.