Re: Drop column constraint [FIXED]

On 10/30/20 8:54 AM, Rich Shepard wrote:
> 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

Actually unique is not the name, it is the constraint type. You can
create your own name when creating the constraint or Postgres will
create one for you.

> latter, and adding 'cascade' (because the dependent table is empty) did the
> trick.
>
> Thank you,
>
> Rich
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com