Re: Binary support for pgoutput plugin

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Binary support for pgoutput plugin
Дата
Msg-id 20200715024753.tn3bnjj4uxrqt6qy@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Binary support for pgoutput plugin  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Binary support for pgoutput plugin  (Dave Cramer <davecramer@gmail.com>)
Список pgsql-hackers
Hi,

On 2020-07-14 22:28:48 -0400, Tom Lane wrote:
> Andres Freund <andres@anarazel.de> writes:
> > What is the gain in having these checks? recv functions need to be safe
> > against arbitrary input, so a type crosscheck doesn't buy additional
> > safety in that regard. Not that a potential attacker couldn't just
> > change the content anyways?
> 
> You're confusing security issues with user-friendliness issues.
> Detecting that you sent the wrong type via an OID mismatch error
> is a lot less painful than trying to figure out why you've got
> errors along the line of "incorrect binary data format".

An oid mismatch error without knowing what that's about isn't very
helpful either.

How about adding an errcontext that shows the "source type oid", the
target type oid & type name and, for records, the column name of the
target table? That'd make this a lot easier to debug.

Greetings,

Andres Freund



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Is it useful to record whether plans are generic or custom?
Следующее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: GSSENC'ed connection stalls while reconnection attempts.