| From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "'Kaare Rasmussen'" <kar(at)kakidata(dot)dk>, "'jm(dot)poure(at)freesurf(dot)fr'" <jm(dot)poure(at)freesurf(dot)fr> |
| Cc: | "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Add OR REPLACE clauses to non-FUNCTION object creat |
| Date: | 2002-01-23 14:24:07 |
| Message-ID: | FED2B709E3270E4B903EB0175A49BCB10B5294@dogbert.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> -----Original Message-----
> From: Kaare Rasmussen [mailto:kar(at)kakidata(dot)dk]
> Sent: 23 January 2002 14:10
> To: jm(dot)poure(at)freesurf(dot)fr
> Cc: pgsql-hackers(at)postgresql(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Krug | 2002-01-23 14:43:00 | Re: Add OR REPLACE clauses to non-FUNCTION object creation in PostgreSQL 7.3 |
| Previous Message | Gavin Sherry | 2002-01-23 14:22:22 | Re: Add OR REPLACE clauses to non-FUNCTION object creation |