nt_incident_id' AS integer)
> FROM xxx WHERE attributes->'account_incident_id' ~ '^[0-9]+$';
>
> On the remote server, create a foreign table on the new view and perform
> your test.
>
> Just curious.
>
> -Greg
>
> On Wed, Apr 17, 2019 at 2:59 PM
assumption is that any function
> with at least one input of a collatable type is collation-sensitive.
> Here you're getting a default collation from the text literal, and
> postgres_fdw doesn't want to assume that the remote end would choose
> the same collation.
>
>
4/16/19 9:40 PM, Jorge Torralba wrote:
> > Thanks for taking the time to look.
> >
> > Both servers are on
> >
> >version
> >
> -
