From: | sean(dot)johnston(at)edgeintelligence(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | sean(dot)johnston(at)edgeintelligence(dot)com |
Subject: | BUG #14890: Error grouping by same column twice using FDW |
Date: | 2017-11-07 13:49:48 |
Message-ID: | 20171107134948.1508.94783@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14890
Logged by: Sean Johnston
Email address: sean(dot)johnston(at)edgeintelligence(dot)com
PostgreSQL version: 10.0
Operating system: Linux Ubuntu
Description:
Using user 'sean' with database 'sean':
create extension postgres_fdw;
create table tbl (col1 integer);
create server loop foreign data wrapper postgres_fdw options ( host
'localhost', dbname 'sean' );
create user mapping for sean server loop options ( user 'sean' );
create foreign table loop_tbl (col1 integer) server loop options (
table_name 'tbl' );
select col1, col1 from loop_tbl group by 1, 2;
psql:t.sql:7: ERROR: targetlist item has multiple sortgroupref labels
From | Date | Subject | |
---|---|---|---|
Next Message | Raphael Hertzog | 2017-11-07 13:54:54 | Fails to work on live images due to fsync() on pg_commit_ts before doing any write there |
Previous Message | Jan Przemysław Wójcik | 2017-11-07 12:51:35 | Re: Fwd: pg_trgm word_similarity inconsistencies or bug |