Re: Granting Browser Access to pgsql database. - Mailing list pgsql-novice

From Larry Rosenman
Subject Re: Granting Browser Access to pgsql database.
Date
Msg-id 20001116063326.A9119@lerami.lerctr.org
Whole thread Raw
In response to Re: Granting Browser Access to pgsql database.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
* Tom Lane <tgl@sss.pgh.pa.us> [001115 23:05]:
> Larry Rosenman <ler@lerctr.org> writes:
> > * James Snelling <fatboy2000@btinternet.com> [001115 14:09]:
> >> However, I still get the line:
> >> NOTICE:  Unrecognized variable client_encoding
>
> > The DB probably was built with --enable-multibyte set, but psql is
> > finding a libpq that doesn't have it.
>
> Other way round, actually: libpq is sending a SET command to set the
> client-side multibyte encoding, and the backend doesn't know what to
> do with it.  It's harmless enough, as long as you aren't expecting
> multibyte characters to work ;-)
>
> For 7.1, I've tweaked the backend so that even without
> --enable-multibyte, it will accept SET client_encoding = 'SQL_ASCII'
> (but *not* any other value).  This should eliminate unnecessary
> notices when using clients compiled with a different feature set.
Thanks, Tom.  I knew I had seen this with a mis-match.

--
Larry Rosenman                      http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

pgsql-novice by date:

Previous
From: "turing2000"
Date:
Subject: ...
Next
From: "Luke Tudor"
Date:
Subject: Problem with multi-connection to database