Sample Header Ad - 728x90

Pass information to another table with the same inherit

0 votes
1 answer
166 views
Suppose the following scenario ... I have two tables (A, B) that inherit from a Z table, the SGBD is postgresql, these tables do not have an additional column, my question is how to pass a row from table A to table B that have the same inheritance. The Table Z has a state column, with that column i decide which is the destiny of the data that has been inserted, this with a trigge, when execute a insert query the triger is activate and with condition is redirecte to child tables. Now, if the state change, how can i pass to table A to table B.?? supose state is a varchar data type and the value is 'A' go to table A and if the value is 'B' go to table B, the constranint in the tables is something like that... table A constraint.. CONSTRAINT only_A CHECK (state = 'A') table B constraint.. CONSTRAINT only_A CHECK (state = 'B') ____________ |___Z_TABLE_| | pk | | col1 | | col2 | | col3 | | state | |___________| _______________ ________________ |___A_TABLE____| |____B_TABLE____| | INHERITS (Z) | | INHERITS (Z) | |______________| |_______________| i need to delete and reinsert in the other table or only with chage the value of state column ??? something more hard is... the table Z has a many relation with another tables...
Asked by Roberto Dominguez Cazarin (1 rep)
Nov 18, 2019, 07:33 PM
Last activity: Jul 10, 2025, 10:04 AM