On 12/8/2005 6:12 PM, Andreas Pflug wrote:
That's one point. The other is what is wrong with setting the env var
PGCLIENTENCODING for slon?

Sounds as if this affects all connection a slon process creates? We're talking about *different* encodings.

If slon connects to a remote DB with a
specific client_encoding, the data it receives on FETCH is supposed to
be in exactly that enoding. That means it must connect to another
database (like it's local node DB) with exactly the same encoding,
because that is what the data it is sending is in.

Not necessarily. Quite often, LATIN1 or so is (mistakenly) stored in SQL_ASCII databases.

Aha, so this entire thread is about giving slon the ability to mimick the brokenness of the users application and to cope with inconsistent database installatoins on different servers.

Well, as long as it is something that must be explicitly turned on and is for sure off by default, go ahead and create a patch.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== [EMAIL PROTECTED] #
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Reply via email to