| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: How duplicate values inserted into the primary key column of table and how to fix it |
| Date: | 2019-01-24 15:30:19 |
| Message-ID: | c43f6770-3907-bdc3-44c0-b9c89df9b571@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
On 1/24/19 4:46 AM, Raghavendra Rao J S V wrote:
> Hi All,
>
>
> We are using Postgresql 9.2 database.
>
> In one of the transactional table, I have observed duplicate values for
> the primary key columns.
Best guess a corrupted index. As Hellmuth said more information would be
helpful.
>
> Please guide me how is it possible and how to fix this kind of issue.
>
>
> --
> Regards,
> Raghavendra Rao J S V
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2019-01-24 19:56:00 | Re: BUG #15585: infinite DynamicSharedMemoryControlLock waiting in parallel query |
| Previous Message | Tom Lane | 2019-01-24 15:03:12 | Re: Suggestion: include interruption method for \watch option (page 1922, PostgreSQL 11.1 Documentation) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoff Winkless | 2019-01-24 15:32:03 | Re: Casting Integer to Boolean in assignment |
| Previous Message | Adrian Klaver | 2019-01-24 15:28:37 | Re: Casting Integer to Boolean in assignment |