Re: encoding of PostgreSQL messages - Mailing list pgsql-general

From Tom Lane
Subject Re: encoding of PostgreSQL messages
Date
Msg-id 19896.1234107496@sss.pgh.pa.us
Whole thread Raw
In response to Re: encoding of PostgreSQL messages  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: encoding of PostgreSQL messages
Re: encoding of PostgreSQL messages
Re: encoding of PostgreSQL messages
Re: encoding of PostgreSQL messages
List pgsql-general
Peter Eisentraut <peter_e@gmx.net> writes:
> Bruce Momjian wrote:
>> Can someone comment on this?

> Looks like a horrible hack to me.  Recoding stuff to the client encoding
> in the server outside the existing recoding mechanism looks pretty evil
> to me.  Plus, it does not address the problem of what happens to
> messages sent before this, it just moves the point of "before" a bit
> earlier for some special cases.

> I think we have discussed more proper solutions earlier in this thread.
>   IMO the best approach would be for the client to include the client
> encoding in the startup package.

Huh?  Clients already do that (or at least some are capable of it,
including libpq).  The hard problems are (1) there's still a "before",
ie we might fail before scanning the options in the packet, and (2)
the sent encoding might itself be invalid, and you still have to report
that somehow.

I believe the only real "fix" is to guarantee that messages are sent
as untranslated ASCII until we have sent an encoding indicator at
the end of the startup sequence.  Which has its own pretty clear
downside: no more translation of authorization failures.

            regards, tom lane

pgsql-general by date:

Previous
From: Josh Harrison
Date:
Subject: problem connecting oracle and postgres database
Next
From: Iñigo Barandiaran
Date:
Subject: Re: Install Postgre while installing Other software.