Re: Can't replace default converter. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Can't replace default converter.
Date
Msg-id 8548.1238506965@sss.pgh.pa.us
Whole thread Raw
In response to Can't replace default converter.  (Roman <Roman_Khlystik@ukr.net>)
List pgsql-hackers
Roman <Roman_Khlystik@ukr.net> writes:
> db_server=# set client_encoding to 'alt';
> server closed the connection unexpectedly
>        This probably means the server terminated abnormally
>        before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.

> Is anyone can tell me what I'm doing wrong?

Two suggestions:

1. Use the latest release (from two weeks ago).  You are probably
tickling the bug that causes a failure in an output converter to
become an infinite recursion.

2. Don't try to replace the output converter.  You don't seem to
need that for your stated problem, and doing so exposes you to
problems in figuring out what's going wrong.

Also, yes, you will need to drop the system's conversion function
(or else mess with your search_path to make yours be found first).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Can't replace default converter.
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] pgstattuple triggered checkpoint failure and database outage?