Re: pg_dump error - LOCALIZATION PROBLEM

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@esg.com.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@gmx.net   http://funkturm.homeip.net/~peter