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

Hi Andrew,

Yes there are indexes on both tables, and the issue only shows up with high volumes.

Note I have subsequently isolated the issue down to a pg_dump 10 to pg_restore 11 using -Fc.

Kind Regards,

PAUL SCHAAP / General Manager

IPG Solutions Pty Limited
Full Service eCommerce Payments Partner

Level 6, Blade Building, 69-71 Walker Street, North Sydney, NSW, Australia
W www.ipggroup.com <http://www.ipggroup.com/> | M +61-4-0307-0000 <tel:+61403070000>

> On 2 Nov 2018, at 02:43, Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> wrote:
>
>>>>>> "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)

--

PRIVACY & CONFIDENTIALITY NOTICE

The information contained in this
email is intended for the named recipients  only.  It may contain
privileged and confidential information and if you are  not the intended
recipient, you should not copy it or disclose its contents  to any other
person, or take any action in reliance on it.  If you have  received this
email in error, please notify us immediately by return email.