Re: Fw: OID - Mailing list pgsql-admin

If you need a unique, arbitrary ID for each record in your tables -- which is almost always a good thing to have, the
OIDdoes the job automatically. It has the additional benefit of being unique in the entire database. The only problem I
haveis if records are imported from other databases, in which case the OID is changed or at risk of being duplicated.
Ifyou assign your own unique ID you can ensure that merged records preserve their ID. I advise using the unique ID only
internallyand never having a user enter or reference it.<br /><br /> Jodi Kanter wrote:<br /><blockquote
cite="mid01e701c24563$00413ef0$de138f80@virginia.edu"type="cite"><style></style><div><font face="Times New Roman">Does
anyonehave a comment on the email below? Is there a general consensus on whether or not to use OIDs with version
7.2?</font></div><div><fontface="Times New Roman">Thanks</font></div><div><font face="Times New
Roman">Jodi</font></div><div> </div><divstyle="font-family: arial; font-style: normal; font-variant: normal;
font-weight:normal; font-size: 10pt; line-height: normal; font-stretch: normal; font-size-adjust: none;">----- Original
Message----- <div style="background: rgb(228,228,228) none repeat scroll 0%;"><b>From:</b> <a
href="mailto:jkanter@virginia.edu"title="jkanter@virginia.edu">Jodi Kanter</a></div><div><b>To:</b> <a
href="mailto:pgsql-admin@postgresql.org"title="pgsql-admin@postgresql.org">Postgres Admin
List</a></div><div><b>Sent:</b>Friday, August 16, 2002 10:19 AM</div><div><b>Subject:</b> OID</div></div><div><br
/></div><div><fontface="Times New Roman">Can anyone point me to some documentation on the use of OIDs? Why might I need
them?How to remove them in version 7.2? ..etc...</font></div><div><font face="Times New
Roman">Thanks</font></div><div><fontface="Times New Roman">Jodi Kanter</font></div><div><div class="Section1"><p
class="MsoNormal"><i><spanstyle="font-family: Arial; font-size: 9pt;">_______________________________<br
/></span></i><i><spanstyle="font-size: 10pt;">Jodi L Kanter<br /> BioInformatics Database Administrator<br />
Universityof Virginia<br /> (434) 924-2846<br /><a
href="mailto:jkanter@virginia.edu">jkanter@virginia.edu</a></span></i><spanstyle="font-family: Arial; font-size:
11pt;"><brstyle="" /><br style="" /></span><p class="MsoNormal"><span style="font-family: Arial; font-size:
11pt;"> </span><pclass="MsoNormal"><i><span style="font-family: Arial; font-size: 9pt;"> </span></i><p
class="MsoNormal"><i><spanstyle="font-family: Arial; font-size: 9pt;"> </span></i></div></div></blockquote><br />