Can we use inheritance in PostgreSQL for tables containing reference keys to another table?

Question

I have 2 tables named item and itemdetail. The itemdetail table contains more than 200,000 records. The itemdetail table has reference keys to other tables and I'd like to partition this table by date (once per every year).

What I'd like to know is how I could partition the itemdetail table as it contains reference keys to many other tables. I read somewhere that we can not partition or use inheritance if table contains any reference keys.

Does anyone have any suggestions on how to achieve this?

Thanks

Craig Ringer · Accepted Answer · 2013-08-16 07:21:59Z

2

In PostgreSQL (9.3)'s current inheritance-based implementation of partitioning, you pretty much get partitioning or foreign key enforcement.

Partitioned tables can reference other tables as foreign keys, but they cannot really be the subject of a foreign key reference from another table unless the related tables are also partitioned on the same key, so their references can be to the same sub-table.

answered Aug 16, 2013 at 7:21

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can we use inheritance in PostgreSQL for tables containing reference keys to another table?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related