GDA: empty PostgreSQL table failed workaround
mrj001 at shaw.ca
Thu Feb 14 15:02:02 EST 2008
Derek Atkins wrote:
> Mark Johnson <mrj001 at shaw.ca> writes:
>> Phil Longstaff wrote:
>>> The slot_id is used to provide a unique primary key. I don't know if it
>>> would work to have the slots table have *no* key, but have an index on
>>> the obj_guid field. The obj_guid field can't be the primary key because
>>> I believe a primary key needs to be unique. Mark?
>> Yes, a primary key does have to be unique. I can't think of any
>> requirement that a table have a primary key though. It is generally
>> good practice. You could have an index on the guid field.
> I think the question was more: Does every table have to HAVE
> a primary key? Yes, the primary key must be unique, but what
> if a table has no primary key? Is that still okay?
I saw it as 2 questions: Does a primary key have to be unique?
Does a table require a primary key?
More information about the gnucash-devel