Re: CREATE OR REPLACE TRIGGER

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: CREATE OR REPLACE TRIGGER
Date: 2002-08-11 15:53:47
Message-ID: 13310.1029081227@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> writes:
> From memory, I think some of the pgadmin guys jumped up and down about it
> for a while: http://fts.postgresql.org/db/mw/msg.html?mid=1353289.

Hmm. I remember Poure asking repeatedly for CREATE OR REPLACE VIEW,
and that makes a lot of sense to me, because other things *can* depend
on a view. (Unfortunately, by the same token it's a lot harder to do.)
The use-case for replacing a trigger is not visible to the naked eye.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Sherry 2002-08-11 16:00:55 Re: CREATE OR REPLACE TRIGGER
Previous Message Gavin Sherry 2002-08-11 15:39:14 Re: CREATE OR REPLACE TRIGGER

Browse pgsql-patches by date

  From Date Subject
Next Message Gavin Sherry 2002-08-11 16:00:55 Re: CREATE OR REPLACE TRIGGER
Previous Message Gavin Sherry 2002-08-11 15:39:14 Re: CREATE OR REPLACE TRIGGER