Re: Drop column constraint [FIXED] - Mailing list pgsql-general

From Rich Shepard
Subject Re: Drop column constraint [FIXED]
Date
Msg-id alpine.LNX.2.20.2010300845490.24081@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Drop column constraint  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Drop column constraint [FIXED]  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Fri, 30 Oct 2020, Adrian Klaver wrote:

> It should be:
> alter table locations drop constraint 'constraint_name';

Adrian,

Yes, I forgot to quote the constraint_name, And, I used the DDL name
'unique' rather than the internal name "locations_loc_nbr_key". Using the
latter, and adding 'cascade' (because the dependent table is empty) did the
trick.

Thank you,

Rich




pgsql-general by date:

Previous
From: Chris Sterritt
Date:
Subject: Re: Drop column constraint
Next
From: Adrian Klaver
Date:
Subject: Re: Drop column constraint [FIXED]