Postgres Pro
Downloads
Home   >   mailing lists

Re: Removing duplicate rows in table - Mailing list pgsql-general

From Rich Shepard
Subject Re: Removing duplicate rows in table
Date
Msg-id 19803246-8b24-5055-ef26-adf7ade3eb@appl-ecosys.com
Whole thread Raw
In response to Re: Removing duplicate rows in table  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Removing duplicate rows in table
List pgsql-general
Tree view 
On Tue, 10 Sep 2024, Adrian Klaver wrote:

> Is there a Primary Key or Unique index on this table?

Adrian,

No. It didn't occur to me to make the project number a PK as this table is
not related to others in the database.

But, yesterday it occurred to me to make the proj_nbr a PK to eliminate
future issues.

Thanks,

Rich

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Removing duplicate rows in table
Next
From: Rich Shepard
Date:
Subject: Re: Removing duplicate rows in table