Thread: Table Partitioning with Foreign Data Wrapper
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??
