parent table insert

[megadawn]

Hi,
How to switch off inserting data into a parent table and insert into children only?

cheers

[funbringer]

Once you've added a child(children), new transactions will automatically insert rows into children.

[megadawn]

yes but it's a double insert, both parent and a child. I don't need any data in a parent table because it goes to a child. Should I just truncate a parent or there is a way NOT to insert into parent at first place?

[funbringer]

yes but it's a double insert, both parent and a child

What do you mean? There's no double insert whatsoever. The tuple is inserted directly into partition.

[megadawn]

sorry guys my bad (or toad)
I looked at data view tab on a parent and it shows everything. When I "select * from ONLY parent_table" there is nothing in there so all good.
thanks problem solved

[funbringer]

thanks problem solved

Good to hear! Please don't hesitate if you have any ideas on how we could improve our documentation to make this case crystal clear :)