> -----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.