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 87zhus4xg5.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
>>>>> "Paul" == Paul Schaap <ps@ipggroup.com> writes:

 Paul> Hi Jeff,
 Paul> I have it now but it might be difficult for you to reproduce.

 Paul> 1) pg_dump a lookup table from a Postgres 10(.5) with -Fc and
 Paul> pg_restore to Postgres 11

 Paul> 2) Join to the table in a view, but when you join do an INTEGER
 Paul> cast

 Paul> 3) Test with different quantities of data as it works with
 Paul> smaller quantities of data, but fails with larger:

Are there any indexes on either table?

-- 
Andrew (irc:RhodiumToad)


pgsql-bugs by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: BUG #15467: The database subdirectory "pg_tblspc/1932420460/PG_10_201707211/16400" is missing.
Next
From: Andrew Gierth
Date:
Subject: Re: BUG #15477: Procedure call with named inout refcursor parameter - "invalid input syntax for type boolean" error