<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h3
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:13.5pt;
font-family:"Times New Roman";
font-weight:bold;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hello Folks,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Are OIDs something to be worried about with PostGIS, since
they will not be manadatory in the future for PostgreSQL?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Partial PostgreSQL FAQ:<o:p></o:p></span></font></p>
<h3 style='margin:0in;margin-bottom:.0001pt'><a name=4.12><b><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial;font-weight:normal'>4.12</span></font></b></a><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;font-weight:
normal'>) What is an OID? What is a CTID?<o:p></o:p></span></font></h3>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Every row that is created in
PostgreSQL gets a unique OID unless created WITHOUT OIDS. OIDs are
autotomatically assigned unique 4-byte integers that are unique across the
entire installation. However, they overflow at 4 billion, and then the OIDs
start being duplicated. PostgreSQL uses OIDs to link its internal system tables
together.<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>To uniquely number columns in user
tables, it is best to use SERIAL rather than OIDs because SERIAL sequences are
unique only within a single table. and are therefore less likely to overflow. SERIAL8
is available for storing eight-byte sequence values.<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>CTIDs are used to identify specific
physical rows with block and offset values. CTIDs change after rows are
modified or reloaded. They are used by index entries to point to physical rows.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Partial PostGIS mail from <a
href="http://postgis.refractions.net/pipermail/postgis-users/2005-May/007995.html">http://postgis.refractions.net/pipermail/postgis-users/2005-May/007995.html</a>:<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Ok. Next release will have OID usage
forced.<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Both 1.0 and HEAD branches updated
like this.<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>I wouldn't know where to put the
workaround documentation, hopefully<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>affected people are ok with this
list's archive.<o:p></o:p></span></font></p>
<p style='margin:0in;margin-bottom:.0001pt'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Paul<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>R. Paul Warriner<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Network Coordinator<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Town of <st1:place w:st="on"><st1:PlaceName
w:st="on">Orchard</st1:PlaceName> <st1:PlaceType w:st="on">Park</st1:PlaceType></st1:place><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:Street w:st="on"><st1:address w:st="on"><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>4295 South Buffalo St</span></font></st1:address></st1:Street><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>Orchard Park</span></font></st1:City><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>, <st1:State
w:st="on">NY</st1:State> <st1:PostalCode w:st="on">14127</st1:PostalCode></span></font></st1:place><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>(716) 662-6403<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>(716) 662-6479 fax<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>