| From: | Rod Taylor <pg(at)rbt(dot)ca> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: drop if exists |
| Date: | 2005-10-15 01:32:21 |
| Message-ID: | 1129339941.24136.70.camel@home |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 2005-10-14 at 20:29 -0400, Andrew Dunstan wrote:
> 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.
I would rather have a 'rollback or release savepoint' command which
would rollback to the savepoint if there was an error or release it
otherwise.
This way any command or combination of commands could be aborted or
continued as a group in a statically defined script.
--
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-10-15 02:43:07 | Re: Open items |
| Previous Message | Alvaro Herrera | 2005-10-15 01:32:02 | Re: drop if exists |