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.klaver@aklaver.com