Re: conditional dropping of columns/constraints

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: conditional dropping of columns/constraints
Date: 2009-05-06 16:32:17
Message-ID: 4A01BB91.3000401@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 05/04/2009 04:10 PM, Andres Freund wrote:
> Would a patch adding 'IF EXISTS' support to:
> - ALTER TABLE ... DROP COLUMN
> - ALTER TABLE ... DROP CONSTRAINT
> possibly be accepted?
A first version of a patch is attached:
- allows [ IF EXISTS ] for both, conditional dropping of columns and
constraints
- adds two tiny additions to the alter_table regression suite
- adds minimal documentation (my wording might be completely off)

As this is my first patch to PG I am happy with most sort of feedback.

Andres

Attachment Content-Type Size
drop-col-if-exists-v1.context.patch text/x-diff 19.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2009-05-06 17:15:07 Re: text_pattern_ops and complex regexps
Previous Message Heikki Linnakangas 2009-05-06 16:26:22 Re: BUG #4796: Recovery followed by backup creates unrecoverable WAL-file