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@xxxxxxxxxxx
