From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Erol Öz <eroloz(at)esg(dot)com(dot)tr> |
Cc: | PostgreSQL General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dump error - LOCALIZATION PROBLEM |
Date: | 2001-09-14 15:12:29 |
Message-ID: | Pine.LNX.4.30.0109141709410.691-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Erol Öz writes:
> I think Tom Lane is right as always. My postgresql server was
> configured with --enable-locale option and it works perfect with
> Turkish stuff. However I could not find a solution to the problem
> below.
Untested, but try this:
Edit src/backend/commands/variable.c, look for the function
parse_XactIsoLevel(). Change the code that looks like this:
if (strcasecmp(value, "SERIALIZABLE") == 0)
XactIsoLevel = XACT_SERIALIZABLE;
else if (strcasecmp(value, "COMMITTED") == 0)
XactIsoLevel = XACT_READ_COMMITTED;
into:
if (strcmp(value, "serializable") == 0)
XactIsoLevel = XACT_SERIALIZABLE;
else if (strcmp(value, "committed") == 0)
XactIsoLevel = XACT_READ_COMMITTED;
Recompile and install.
> <eroloz(at)esg(dot)com(dot)tr> writes:
> >> 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 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?
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
From | Date | Subject | |
---|---|---|---|
Next Message | Tomisław Kityński | 2001-09-14 15:50:36 | isNullable() |
Previous Message | chris_five | 2001-09-14 15:01:12 | Re: Blob datatype / image storing |
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Rice | 2001-09-14 16:06:20 | Re: Where do they find the time??? Great Bridge closed now!!!?? |
Previous Message | Peter Harvey | 2001-09-14 15:00:35 | System Tables |