Re: Misleading error message in logical decoding for binary plugins

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Misleading error message in logical decoding for binary plugins
Date: 2014-08-29 15:17:08
Message-ID: CAB7nPqRCoCrrf84vHrvdRk8+9RGZbRfBkWMri9_79TFkmz41Fg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Aug 29, 2014 at 11:39 PM, Andres Freund <andres(at)2ndquadrant(dot)com>
wrote:

> Yes. The output plugin declares whether it requires the *output method*
> to support binary data. pg_logical_slot_peek_changes *can not* support
> binary data because it outputs data as
> text. pg_logical_slot_peek_binary_changes *can* support binary data
> because it returns bytea (and thus it also can output text, because
> that's essentially a subset of binary data).
>
Thanks for the explanations. This would meritate more details within the
docs, like what those two modes actually do and what the user can expect as
differences, advantages and disadvantages if he chooses one or the other
when starting decoding...
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-08-29 15:18:54 Re: Why data of timestamptz does not store value of timezone passed to it?
Previous Message Greg Stark 2014-08-29 15:10:18 Re: Why data of timestamptz does not store value of timezone passed to it?