I've upgraded to 6.5.3 from RPM but 'set client_encoding' still says
'unknow variable'. How can I know whether RPM was compiled
with --enable-locale and --with-mb=LATIN2? And if it wasn't,
could I humbly suggest it for next version?
If I knew it wasn't compiled with the right options, I could just
take a deep breath and try to recompile it myself. However, there's
no info about compile options used to prepare RPM and I'm not
sure I'm not doing some trivial mistake... I'd like to avoid recompiling
the whole thing if I can.
- Robert
P.S. David, thanks for your help so far. I forgot to send my last mail
to the list and sent it to your address only instead. Sorry.
David Sauer wrote:
> >>>> "Robert" == Robert <robert@robert.cz> writes:
>
> Robert> netkof=> show client encoding;
> Robert> ERROR: parser: parse error at or
>
> Sorry, my mistake. The right name is 'client_encoding' (with underscore).
>
> Example:
>
> david=> set client_encoding to 'latin2';
> SET VARIABLE
>
> Robert> Hmm, what did you say I should write? Well, this is PG6.5.2
> Robert> installed from RPM, should it be compiled with some special
> Robert> option? Thanks.
>
> Yes, postgres must be compiled with --enable-locale and --with-mb=LATIN2.
> And, I'am not sure, but may want upgrade to 6.5.3.
>
> --
> * David Sauer, student of Czech Technical University
> * electronic mail: davids@penguin.cz (mime compatible)
>
> ************