BUG #15475: Views over CITEXT columns return no data

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: ps(at)ipggroup(dot)com
Subject: BUG #15475: Views over CITEXT columns return no data
Date: 2018-10-31 22:44:12
Message-ID: 15475-11a7a783fed72a36@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15475
Logged by: Paul Schaap
Email address: ps(at)ipggroup(dot)com
PostgreSQL version: 11.0
Operating system: OSX 10.14 and Ubuntu 18.10
Description:

The steps to reproduce are:
1) Install CITEXT extension
2) Create a table with a CITEXT column
3) Create a view (not materialised) over the table
4) Query the view filtering on the CITEXT column

No data gets returned when querying via the view, this works under
Postgresql 10 but not 11.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2018-10-31 23:00:04 Re: BUG #15475: Views over CITEXT columns return no data
Previous Message David G. Johnston 2018-10-31 20:34:18 Re: BUG #15474: Special character escape sequences need better documentation, or more easily found documentation