Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #8662: psql -H and ts_headline - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #8662: psql -H and ts_headline
Date
Msg-id 52B463CC.50300@gmx.net
Whole thread Raw
In response to BUG #8662: psql -H and ts_headline  (cbfgterfdy@zacglen.net)
Responses Re: BUG #8662: psql -H and ts_headline
List pgsql-bugs
Tree view 
On 12/6/13, 7:03 PM, cbfgterfdy@zacglen.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.

pgsql-bugs by date:

Previous
From: Umesh Kirdat
Date:
Subject: Duplicate key violates unique constraint
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #8139: initdb: Misleading error message when current user not in /etc/passwd