Re: Duplicate data even with primary keys enabled

Поиск
Список
Период
Сортировка
От Jayson Hreczuck
Тема Re: Duplicate data even with primary keys enabled
Дата
Msg-id CAHg7=h7hGMWvbhrq6hbQmzX8pEN6_Fp_FmTX8Wy70Yjk=aJ4cQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Duplicate data even with primary keys enabled  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: Duplicate data even with primary keys enabled  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
Very curious about this too.  Corruption of indexes does occur but less than a handful of times in my 30 years of DBA experience, and is usually due to hardware failure or some immediate cause.

Script the table and provide the query.


On Sat, Oct 29, 2022, 8:16 AM Scott Ribe <scott_ribe@elevated-dev.com> wrote:
Actual table definition, sample query, and output, please.

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/



> On Oct 29, 2022, at 5:20 AM, abbas alizadeh <ramkly@yahoo.com> wrote:
>
> I faced the same issue last week.
> We had duplicated records on primary key.



В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: Duplicate data even with primary keys enabled
Следующее
От: Samed YILDIRIM
Дата:
Сообщение: Re: Duplicate data even with primary keys enabled