Re: drop if exists

Rod Taylor wrote:

>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.
>
>  
>

I don't see that they are mutually exclusive, although one could achieve 
the effect this way.

cheers

andrew