I am a novice PG user. I would like to know which among
these data types are best suited to be used as Primary/Foreign Keys. Some of my
auto generated in postgres, but not when you use ODBC (i.e. MS Access as a frontend). When using it in another table as foreign key
you have to know which number corresponds to which. Once the sequence
is accidentally altered, an extra manipulation is needed (setval, etc)
More flexible than SERIAL autonumber but similarly you have to know the exact number in the parent table when filling the child table. Plus you enter the numbers manually.
use of codes alphanumeric is easier to remenber but some argues it will degrade query performance.
Some expert advise please. If this is not the proper place to ask these questions then please point me to a proper
NEW! Get Windows Live FREE.
pgsql-novice by date
|Next:||From: Jana||Date: 2009-05-16 17:54:34|
|Subject: Custom sorting|
|Previous:||From: A. Kretschmer||Date: 2009-05-15 11:52:03|
|Subject: Re: Transform table data|