Re: joined tables with USING and GROUPBY on the USING() column - Mailing list pgsql-general

From Adrian Klaver
Subject Re: joined tables with USING and GROUPBY on the USING() column
Date
Msg-id f5982716-5753-ca63-dbe1-6989441e689f@aklaver.com
Whole thread Raw
In response to Re: joined tables with USING and GROUPBY on the USING() column  (Geoff Winkless <pgsqladmin@geoff.dj>)
Responses Re: joined tables with USING and GROUPBY on the USING() column  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-general
On 09/07/2016 01:11 PM, Geoff Winkless wrote:
> On 7 Sep 2016 9:01 p.m., "Adrian Klaver" <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>> What happens if you table qualify all the references to token?
>
> Oh it definitely fixes it; I was more confused why it works on one
> server and not another. I thought perhaps there was a config option to
> allow more lax naming in this way. If not I'll have to look more closely
> at the table defs, although I thought I had checked they were the same.

I would check search_path to see if you have another table of same name
in the path on the problem machine versus on the other machines.

>
> Geoff
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: joined tables with USING and GROUPBY on the USING() column
Next
From: Ken Tanzer
Date:
Subject: How to assemble all fields of (any) view into a string?