Re: joined tables with USING and GROUPBY on the USING() column

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: joined tables with USING and GROUPBY on the USING() column
Дата
Msg-id f5982716-5753-ca63-dbe1-6989441e689f@aklaver.com
обсуждение исходный текст
Ответ на Re: joined tables with USING and GROUPBY on the USING() column  (Geoff Winkless <pgsqladmin@geoff.dj>)
Ответы Re: joined tables with USING and GROUPBY on the USING() column  (Geoff Winkless <pgsqladmin@geoff.dj>)
Список 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 по дате отправления:

Предыдущее
От: Geoff Winkless
Дата:
Сообщение: Re: joined tables with USING and GROUPBY on the USING() column
Следующее
От: Ken Tanzer
Дата:
Сообщение: How to assemble all fields of (any) view into a string?