Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dump error

pg_dump error

From
"Erol Öz"
Date:
Hi,
I get an error when the following command executed;
/usr/local/pgsql/bin/pg_dump trollandtoad > trollandtoad.out
 
SET TRANSACTION command failed. Explanation from backend: 'ERROR:  Bad TRANSACTION ISOLATION LEVEL (serializable)
 
Where should I look at for a solution.
 
Thanks in advance.
Erol

Re: pg_dump error

From
Tom Lane
Date:
"=?iso-8859-9?B?RXJvbCDWeg==?=" <eroloz@esg.com.tr> writes:
> I get an error when the following command executed;=20
> /usr/local/pgsql/bin/pg_dump trollandtoad > trollandtoad.out

> SET TRANSACTION command failed. Explanation from backend: 'ERROR:  Bad TRAN=
> SACTION ISOLATION LEVEL (serializable)

Hmm.  It would seem that strcasecmp() on your platform reports that the
strings "SERIALIZABLE" and "serializable" are not equal.  A locale
problem perhaps?

            regards, tom lane