Re: conditional dropping of columns/constraints - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: conditional dropping of columns/constraints
Date
Msg-id 4A003769.1050600@dunslane.net
Whole thread Raw
In response to Re: conditional dropping of columns/constraints  (Chris Browne <cbbrowne@acm.org>)
Responses Re: conditional dropping of columns/constraints  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers

Chris Browne wrote:
> For columns, I'd *much* more frequently be interested in
>    ALTER TABLE ... ADD COLUMN IF NOT EXISTS ...
>
>
>   

We have debated CREATE ... IF NOT EXISTS in the past, and there is no 
consensus on what it should do, so we don't have it for any command. 
That is quite a different case from what's being asked for, and the two 
should not be conflated.

cheers

andrew


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: conditional dropping of columns/constraints
Next
From: Andres Freund
Date:
Subject: Re: conditional dropping of columns/constraints