On Thu, Oct 27, 2022 at 12:18 PM Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
On 2022-10-27 10:55:31 +0300, Kristjan Mustkivi wrote: > We use dockerized postgres.
So that means you aren't just replacing PostgreSQL, but your complete OS (except the kernel). What is the source of your docker images? Do they all use the same base OS distribution? Are the locale definitions the same?
(Just trying to rule other other possible error sources.)
> I do apologize, but I do not understand the value of doing that select > juggling.
I think Allan may have misread your mail.
hp
-- _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@hjp.at | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!"
Hi Peter,
It was a long shot. I was trying to suggest determining if indeed the data does actually contain duplicating values in the mentioned columns.
Then test to see if the index construction on the new table can be successful on both versions and see if the error is reproducible.
