Re: DROP TYPE without error? - Mailing list pgsql-sql

From Harald Fuchs
Subject Re: DROP TYPE without error?
Date
Msg-id pusm22g3ty.fsf@srv.protecting.net
Whole thread Raw
In response to DROP TYPE without error?  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
List pgsql-sql
In article <1112817807.4254408fecadc@webmail.telus.net>,
Mischa <mischa.Sandberg@telus.net> writes:

> I've got a similar request for other objects that do/do not exist.
> Maybe it's just that I got lazy using MSSQL, but it sure was convenient
> to have:

>    IF object_id('WorkTable') IS NULL
>        CREATE TABLE WorkTable(...
> etc.

I got lazy using MySQL, where it was convenient to have CREATE TABLE IF NOT EXISTS tbl (...)
and DROP TABLE IF EXISTS tbl

This is the only feature of MySQL I really miss.



pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Table PARTITION
Next
From: TJ O'Donnell
Date:
Subject: Re: 9.17.5. Row-wise Comparison