Re: CREATE OR REPLACE TRIGGER not supported?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: CREATE OR REPLACE TRIGGER not supported?
Date: 2004-09-13 01:31:52
Message-ID: 4144F888.6080403@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> A few days ago, I found that "CREATE OR REPLACE TRIGGER"
> is not allowed on 7.4.2. However, functions and rules allow
> "CREATE OR REPLACE" statement.
>
> Is threre any reason not to support "CREATE OR REPLACE"
> only for triggers?

Because the oid of a trigger doesn't matter. You can go being; drop
trigger; create trigger; commit; atomically.

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-09-13 03:00:19 Re: CREATE OR REPLACE TRIGGER not supported?
Previous Message John Hansen 2004-09-13 01:11:51 Re: CREATE OR REPLACE TRIGGER not supported?