Re: DROP TYPE without error?

From: Harald Fuchs <use_reply_to(at)protecting(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: DROP TYPE without error?
Date: 2005-04-07 12:37:45
Message-ID: pusm22g3ty.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

In article <1112817807(dot)4254408fecadc(at)webmail(dot)telus(dot)net>,
Mischa <mischa(dot)Sandberg(at)telus(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2005-04-07 12:37:47 Re: Table PARTITION
Previous Message Richard Huxton 2005-04-07 12:32:53 Re: Table PARTITION