Skip site navigation (1) Skip section navigation (2)

Re: dump/restore results in duplicate key violation with 7.4.6.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dan Libby <dan(at)libby(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: dump/restore results in duplicate key violation with 7.4.6.
Date: 2004-11-14 00:12:28
Message-ID: 4026.1100391148@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Dan Libby <dan(at)libby(dot)com> writes:
> 1) I don't understand why a difference in locale should cause a 
> duplicate key error, especially when both databases were created using 
> 'UNICODE' encoding.  Is this valid behavior or a postgres bug?

The past reports I've seen of such misbehavior appeared to result
from strcoll() failing to cope well with multibyte sequences that
were illegal according to the selected locale's idea of the character
set in use.  You can get burnt by this quite easily if you set the
database encoding to something not compatible with the locale.
If you didn't make that mistake, then I'd bet on Postgres having a
more liberal idea of what are valid characters in the encoding than
the locale definition does.  Whether that is Postgres' bug or the
locale definition's is impossible to say without more data.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Gaetano MendolaDate: 2004-11-14 18:39:52
Subject: Re: max connections from one ip
Previous:From: Миков НиколайDate: 2004-11-13 06:19:02
Subject: max connections from one ip

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group