GDA: empty PostgreSQL table failed workaround

Mark Johnson 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?
>
> -derek
>   
I saw it as 2 questions: Does a primary key have to be unique?
Yes

Does a table require a primary key?
No

Mark




More information about the gnucash-devel mailing list