Table Partitioning with Foreign Data Wrapper

From: Ranjeet Verma <ranjeetverma11(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Table Partitioning with Foreign Data Wrapper
Date: 2016-10-13 08:10:56
Message-ID: CAFc8SBaaNHzSSE62S_3NSUNBBAXwQG0cMmmSfg4jpcwXhBv+1w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,
I need your kind assistance, to learn if it is possible the partition
within a table in foreign server.
Actually I have integrated the whole process but UPDATE and DELETE script
not working fine.

*Here is Example:*
For example Server001 is a main server and Server002 is a secondary server.
At Server001 we have created foreign data wrapper and create a foreign
table and same table replica has been created at Server002. These
functionality are working fine.

Now I have partitioned the table at Server002 into five partition also
having the parent table. and i have attached the BEFORE INSERT trigger on
Parent Table and BEFORE UPDATE and DELETE trigger attached in the all child
tables.

When I try to INSERT, UPDATE and DELETE on parent table (which are possible
by your inheritance process), the INSERT script are working fine but UPDATE
and DELETE script not working properly. Actually on single row update it
gives the multiple updates on another child tables randomly. Same error is
coming to DELETE case.

*EXAMPLE:*
update table_name set applicant_name='Tom Hank' where applicant_id=100;
(where applicant_id is primary key and every record in table are unique.)

When I execute the above SQL script, randomly 3 or 4 records with
applicant_name "Tom Hank" has been updated in another table with out
maching any criteria in where condition. Also these records does not
contains any relation with updated records.

Kindly tell me what I am doing wrong??

Thanks & Regards
Ranjeet Verma
M: -9717991020

Browse pgsql-bugs by date

  From Date Subject
Next Message alexey.ermakov 2016-10-13 10:22:59 BUG #14369: incorrect translation of error message to russian
Previous Message Heikki Linnakangas 2016-10-13 07:59:17 Re: BUG #14344: string_agg(DISTINCT ..) crash