Hi,
It worked.
Thanks a lot.
Regards
Erol
-----Özgün İleti-----
Kimden: Peter Eisentraut <[EMAIL PROTECTED]>
Kime: Erol Öz <[EMAIL PROTECTED]>
Bilgi: PostgreSQL General List <[EMAIL PROTECTED]>
Tarih: 14 Eylül 2001 Cuma 18:03
Konu: Re: [GENERAL] 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.
> <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
