POSTGRES, Insert data into Partition table Failed!!

Jul 30 2021 4:44 PM

Hi there, 

I just got a fail insert into a partition table from a conditioned SELECT from one diferent´s data base server..

I mean:

Scenario A:

EXPORT DATA from db server ¨"A" to PARTITION TABLE in a server "B" it was read all data without errors o warnings but when SELECT in Parttion Table i have 0 records, what failed?

Scenario B

From server B, EXPORT DATA table to a Partition Table, it was read all data without errors o warnings but when SELECT in Parttion Table i have 0 records, what failed?

all of two scenaries FAILED without error messages!!

WAS WRONG??

Thank out there.


Answers (1)