Re: [HACKERS] bytea_output vs make installcheck

Поиск
Список
Период
Сортировка
От neha khatri
Тема Re: [HACKERS] bytea_output vs make installcheck
Дата
Msg-id CAFO0U+9w1oP=gKXt86Lu1GDE24gQkDZaGDCs2s26uGUdX=cDPg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] bytea_output vs make installcheck  (neha khatri <nehakhatri5@gmail.com>)
Ответы Re: [HACKERS] bytea_output vs make installcheck  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Дерево обсуждения

On Wed, Feb 15, 2017 at 10:04 AM, neha khatri <nehakhatri5@gmail.com> wrote:.

Attached are two options for doing that.  One overrides bytea_output locally where-ever needed, and the other overrides it for the entire 'regression' database.

The solution that overrides bytea_output locally looks appropriate. It may not be required to change the format for entire database.
Had there been a way to convert  bytea_output from 'hex' to 'escape' internally, that could have simplified this customization even more.

Well, the conversion from 'hex' to 'escape' is available using the function encode(). 
So the queries that are failing due to the setting bytea_output =  escape, can be wrapped under encode(), to obtain the result in 'escape' format. 
Here is another way to resolve the same problem. The patch is attached.

Regards,
Neha
Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Provide list of subscriptions and publications inpsql's completion
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] bytea_output vs make installcheck