On Thu, 7 Jul 2011, John R Pierce wrote:
if your original table has Primary Key of (sta_type, secondary_type) I would not expect EITHER of those fields to be unique by themselves.... Surely there can be more than one of the same sta_type with different secondary_type's, just as there could be more than one secondary_type with different sta_types.... if either of these fields is unique of and by itself, it doesn't make sense to use the combined primary key.
John, Ah, yes. Of course. That's why the compound primary key is required. I'll redo the table the proper way. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general