On Fri, 30 Oct 2020, Adrian Klaver wrote:
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.
Adrian,
Got it, thanks.
Rich
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
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'
