BUG #14890: Error grouping by same column twice using FDW

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
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

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


Browse pgsql-bugs by date

  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