GDA: empty PostgreSQL table failed workaround

Graham Leggett minfrin at sharp.fm
Thu Feb 14 18:01:46 EST 2008


Derek Atkins wrote:

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

It's perfectly ok, yes - but primary keys are used heavily for 
optimisation. Without them, performance will suffer, particularly while 
generating reports.

Regards,
Graham
--
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3287 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20080215/f8fd0d22/attachment.bin 


More information about the gnucash-devel mailing list