GDA: empty PostgreSQL table failed workaround

Derek Atkins warlord at MIT.EDU
Thu Feb 14 12:45:22 EST 2008

Mark Johnson <mrj001 at> 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 Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL:    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available

More information about the gnucash-devel mailing list