Postgres Pro
Downloads
Home   >   mailing lists

postgres_fdw misbehaviour using "DELETE ... RETURNING *" - Mailing list pgsql-bugs

From Fabrízio de Royes Mello
Subject postgres_fdw misbehaviour using "DELETE ... RETURNING *"
Date
Msg-id CAFcNs+qi7gV4nnWGeWwrj-qyRNOiTfaiWTt6+m5Lr6ov29WXmA@mail.gmail.com
Whole thread Raw
Responses Re: postgres_fdw misbehaviour using "DELETE ... RETURNING *"
List pgsql-bugs
Tree view
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@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@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
Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15080: ecpg on windows doesn't define HAVE_LONG_LONG_INT
Next
From: PG Bug reporting form
Date:
Subject: BUG #15206: Can not import CSV into PostgreSQL