Postgres Pro
Downloads
Home   >   mailing lists

BUG #15475: Views over CITEXT columns return no data - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15475: Views over CITEXT columns return no data
Date
Msg-id 15475-11a7a783fed72a36@postgresql.org
Whole thread Raw
Responses Re: BUG #15475: Views over CITEXT columns return no data
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      15475
Logged by:          Paul Schaap
Email address:      ps@ipggroup.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.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #15474: Special character escape sequences need betterdocumentation, or more easily found documentation
Next
From: Jeff Janes
Date:
Subject: Re: BUG #15475: Views over CITEXT columns return no data