GDA: empty PostgreSQL table failed workaround

Nathan Buchanan nbinont at
Thu Feb 14 13:10:40 EST 2008

On Thu, Feb 14, 2008 at 12:45 PM, Derek Atkins <warlord at> wrote:

> 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?

no. The SQL spec does not require a primary key.

Yes, the primary key must be unique, but what
> if a table has no primary key?  Is that still okay?

yes, it is ok, though performance will usually suffer.


> -derek
> --
>       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
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at

"Even if you are on the right track, you'll get run over if you just sit
there" - Will Rogers

More information about the gnucash-devel mailing list