[GENERAL] populating database, partition table, foreign key constraint Error

Hello, I have a problem about dropping and recovering foreign key constraint. Since we are using table partitioning for table A, records are always directed to one partition by triggers, leaving the parent table A empty. However, for table B where A's id serves as a foreign key, the foreign key

[GENERAL] [partition table] fetchall or fetchone function can not get the returning rows

Hello, I have a problem concerning the partition table. When I store a record into one of the partition and use "RETURNING table_id" or "RETURNING *", I expect the same result when calling fetchall or fetchone function as not using partition. However, it simply returns nothing. Since the ser

[GENERAL] [partition table] python fetchall or fetchone function can not get the returning rows

Hello, I have a problem concerning the partition table. When I store a record into one of the partition and use "RETURNING table_id" or "RETURNING *", I expect the same result when calling fetchall or fetchone function as not using partition. However, it simply returns nothing. Since the seria

[GENERAL] [partition table] fetchall or fetchone function can not get the returning rows

Hello, I have a problem concerning the partition table. When I store a record into one of the partition and use "RETURNING table_id" or "RETURNING *", I expect the same result when calling fetchall or fetchone function as not using partition. However, it simply returns nothing. Since the seria