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

> -----Original Message-----
> From: Kaare Rasmussen [mailto:kar@kakidata.dk] 
> Sent: 23 January 2002 14:10
> To: jm.poure@freesurf.fr
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Add OR REPLACE clauses to non-FUNCTION 
> object creation in PostgreSQL 7.3
> 
> 
> > - 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
> ?? 

No. CREATE OR REPLACE will preserve the object OID and will not break any
dependencies.

Regards, Dave.