Re: BUG #8662: psql -H and ts_headline

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: cbfgterfdy(at)zacglen(dot)net, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8662: psql -H and ts_headline
Date: 2013-12-20 15:35:40
Message-ID: 52B463CC.50300@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 12/6/13, 7:03 PM, cbfgterfdy(at)zacglen(dot)net wrote:
> While "psql -H" is quite useful there is flaw when a query includes
> ts_headline(). The highlighting html gets escaped along with any other html
> special characters.

How would you address that? There is no way for psql or any other
client to know that the text data that is being returned is actually
HTML. A proper fix would be having an HTML data type, or having
ts_headline() return type XML.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2013-12-20 15:46:43 Re: BUG #8139: initdb: Misleading error message when current user not in /etc/passwd
Previous Message Umesh Kirdat 2013-12-20 11:38:55 Duplicate key violates unique constraint