postgres_fdw misbehaviour using "DELETE ... RETURNING *"

From: Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: postgres_fdw misbehaviour using "DELETE ... RETURNING *"
Date: 2018-05-19 01:38:43
Message-ID: CAFcNs+qi7gV4nnWGeWwrj-qyRNOiTfaiWTt6+m5Lr6ov29WXmA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi all,

Using "DELETE ... RETURNING *" against a remote partitioned table (parent)
returns wrong results according attached test case.

I've tested it against all supported versions and got error just in 9.3,
9.4 and 9.5 version.

Attached ziped test case and results:
- fdw_test.sql (main test case script)
- fdw_test.expected.out (expected output)
- fdw_test.result-*.out (wrong results)

Some environment details:

fabrizio(at)macanudo:/tmp
$ uname -a
Linux macanudo 4.13.0-41-generic #46~16.04.1-Ubuntu SMP Thu May 3 10:06:43
UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

fabrizio(at)macanudo:/tmp
$ gcc --version
gcc (Ubuntu 5.4.0-6ubuntu1~16.04.9) 5.4.0 20160609
Copyright (C) 2015 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello

Attachment Content-Type Size
fdw_test.zip application/zip 3.1 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-05-19 09:09:37 BUG #15206: Can not import CSV into PostgreSQL
Previous Message Tom Lane 2018-05-18 18:11:52 Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT