Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE OR REPLACE TRIGGER - Mailing list pgsql-patches

From Tom Lane
Subject Re: CREATE OR REPLACE TRIGGER
Date
Msg-id 19572.1029093992@sss.pgh.pa.us
Whole thread Raw
In response to Re: CREATE OR REPLACE TRIGGER  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses Re: CREATE OR REPLACE TRIGGER
List pgsql-patches
Tree view 
"Dave Page" <dpage@vale-housing.co.uk> writes:
>> The use-case for replacing a trigger is not visible to the
>> naked eye.

> It would be nice for pgAdmin 'cos we can then let users alter properties
> of objects at will.

So implement it as DROP TRIGGER/CREATE TRIGGER.  There's no need for the
backend to provide a special case shortcut...

            regards, tom lane

pgsql-patches by date:

Previous
From: "Dave Page"
Date:
Subject: Re: CREATE OR REPLACE TRIGGER
Next
From: Alvaro Herrera
Date:
Subject: PGPASSWORDFILE env var for libpq