Re: Table Inheritance and Foreign Keys

2019-02-17 Thread Tom Lane
"Riaan Stander" writes: > I've got a scenario where I'm building a table structure that allows for > building a tree. In order to properly separate the different column > requirements I've looked at using table inheritance. > [ but can't point a foreign key at an inheritance tree ] > My question i

Table Inheritance and Foreign Keys

2019-02-17 Thread Riaan Stander
Good day I've got a scenario where I'm building a table structure that allows for building a tree. In order to properly separate the different column requirements I've looked at using table inheritance. Example structure: CREATE TABLE base_table ( idbigint primary key, paren