Re: Add OR REPLACE clauses to non-FUNCTION object creation

From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
To: Kaare Rasmussen <kar(at)kakidata(dot)dk>
Cc: jm(dot)poure(at)freesurf(dot)fr, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Add OR REPLACE clauses to non-FUNCTION object creation
Date: 2002-01-23 14:22:22
Message-ID: Pine.LNX.4.21.0201240121570.17246-100000@linuxworld.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 23 Jan 2002, Kaare Rasmussen wrote:

> > - CREATE OR REPLACE VIEW,
> > - CREATE OR REPLACE TRIGGER.
>
> Isn't it the same as
>
> DROP VIEW name
> CREATE VIEW name
> or
> DROP TRIGGER name
> CREATE TRIGGER name
> ??

The original OID is preserved.

Gavin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2002-01-23 14:24:07 Re: Add OR REPLACE clauses to non-FUNCTION object creat
Previous Message Gavin Sherry 2002-01-23 14:16:22 Re: Add OR REPLACE clauses to non-FUNCTION object creation