From: | Ken Marshall <ktm(at)rice(dot)edu> |
---|---|
To: | De Lan <delandl(at)google(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org, Amit Virmani <avirmani(at)google(dot)com>, Terence Yim <terencey(at)google(dot)com>, Vitalii Tymchyshyn <vitaliit(at)google(dot)com>, Samik Gupta <gupsam(at)google(dot)com>, Albert Shau <ashau(at)google(dot)com> |
Subject: | Re: Duplicate Primary keys in postgresql tables |
Date: | 2023-07-22 17:30:38 |
Message-ID: | ZLwSPl8nSknFnVLF@aart.rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>
> *Our questions:*
>
> Any ideas on what might cause this behavior other than the collation? if it
> is a well-known issue in the pgsql community or it really is the
> coalition that's the root cause, do we have mitigation for this kind of
> issue from happening in future?
>
>
>
> De,
>
> Thanks!
Hi De,
Unless you are having a hardware issue this sort of problem is almost
always an unexpected change in the collation being used. You may be able
to use the ICU collation that has been added to minimize the impacts of
such a change. I would recommend monitoring your collation and if it
changes alert. Also, you need to verify all of the collations if you are
going to upgrade any OS or container OS. Containers are not magic in
this regards. The fix is to reindex if you have a collation change.
Regards,
Ken
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2023-07-22 18:02:52 | Re: Duplicate Primary keys in postgresql tables |
Previous Message | De Lan | 2023-07-22 17:11:37 | Duplicate Primary keys in postgresql tables |