Re: BUG #15475: Views over CITEXT columns return no data

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Paul Schaap <ps(at)ipggroup(dot)com>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15475: Views over CITEXT columns return no data
Date: 2018-11-01 15:43:19
Message-ID: 87zhus4xg5.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "Paul" == Paul Schaap <ps(at)ipggroup(dot)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)

In response to

Responses

Browse pgsql-bugs by date

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