Postgres Pro
Downloads
Home   >   mailing lists

Why is there no ADD CONSTRAINT IF NOT EXISTS ? - Mailing list pgsql-novice

From Stephen Carboni
Subject Why is there no ADD CONSTRAINT IF NOT EXISTS ?
Date
Msg-id CAN-rLW_L0s-nt5AC5A=RLtCjeB-aaZRd-oRfkKf0OeYXCNzHng@mail.gmail.com
Whole thread Raw
Responses Re: Why is there no ADD CONSTRAINT IF NOT EXISTS ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view
I can drop a constraint if it exists, but cannot simply add one if it does not exist. Is there something especially difficult about supporting this?

pgsql-novice by date:

Previous
From: Simon Connah
Date:
Subject: Re: Dealing with multiple currencies with the money type?
Next
From: Tom Lane
Date:
Subject: Re: Why is there no ADD CONSTRAINT IF NOT EXISTS ?