drop if exists

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: drop if exists
Date: 2005-10-15 00:29:43
Message-ID: 43504D77.6060504@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


From time to time the suggestion crops up of allowing a DROP IF EXISTS
... syntax. This seems not unreasonable, and I just spent a few minutes
looking at what might be involved. Especially in the case of a table,
view, sequence and index the changes look like they would be very modest
indeed, and not enormously greater in the case of a type, domain,
conversion and schema.

Is this worth doing? Would it be acceptable?

cheers

andrew

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2005-10-15 00:47:48 Re: drop if exists
Previous Message David Fetter 2005-10-15 00:21:04 Re: slow IN() clause for many cases