Whit Armstrong <armstrong.whit@xxxxxxxxx> writes: > I have a simple example copied from the 8.3 manual on partitioning > (http://www.postgresql.org/docs/8.3/interactive/ddl-partitioning.html). > My question is, if you create a serial type in the parent table which > is meant to be the primary key across all the partitions, how does one > guarantee uniqueness of that key? One doesn't. That is not an appropriate way to set up a partitioned table. You need a primary key that can actually be used as a meaningful partitioning key. In this example, the id is completely useless and what you should be looking at is making the data_value be the primary key. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
