| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Geoff Winkless <pgsqladmin(at)geoff(dot)dj>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: joined tables with USING and GROUPBY on the USING() column |
| Date: | 2016-09-07 20:13:53 |
| Message-ID: | f5982716-5753-ca63-dbe1-6989441e689f@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 09/07/2016 01:11 PM, Geoff Winkless wrote:
> On 7 Sep 2016 9:01 p.m., "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Tanzer | 2016-09-07 20:15:57 | How to assemble all fields of (any) view into a string? |
| Previous Message | Geoff Winkless | 2016-09-07 20:11:53 | Re: joined tables with USING and GROUPBY on the USING() column |