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