On Thu, Oct 27, 2022 at 12:18 PM Peter J. Holzer <hjp-pgsql@xxxxxx> 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@xxxxxx | -- 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.
-Allan.
