Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Gierth
Subject Re: BUG #15475: Views over CITEXT columns return no data
Date
Msg-id 87ftwk4a50.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: BUG #15475: Views over CITEXT columns return no data  (Paul Schaap <ps@ipggroup.com>)
Responses Re: BUG #15475: Views over CITEXT columns return no data  (Paul Schaap <ps@ipggroup.com>)
List pgsql-bugs
Tree view 
>>>>> "Paul" == Paul Schaap <ps@ipggroup.com> writes:

 Paul> Hi Andrew,
 Paul> Here you go:

This is looking like a bug in parallel hash. Do the queries all work if
you do  set enable_parallel_hash=false;  ?

(Going by the row counts in the explains, you got the first two "broken"
and "working" ones backwards)

-- 
Andrew.

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #15437: Segfault during insert into declarative partitionedtable with a trigger creating partition
Next
From: Thomas Munro
Date:
Subject: Re: BUG #15460: Error while creating index or constraint