<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
My version is 1.1.6. Can I upgrade just the PostGIS version without
upgrading PostgreSQL? I am running PostgreSQL 8.2. David<br>
<br>
Mark Cave-Ayland wrote:
<blockquote
cite="mid:59351.86.3.91.160.1221155496.squirrel@ra.siriusit.co.uk"
type="cite">
<blockquote type="cite">
<pre wrap="">I have a PostGIS database that is frequently thowing this error. My
guess is that it is related to the GIS index and the number of NULL
geometries in the table. Because of how I am using Hibernate, I insert
the record with a NULL geometry and then update the record with the
geometry. Has anyone else identified this error and can anyone suggest a
fix?
Thanks, David
</pre>
</blockquote>
<pre wrap=""><!---->
Hi David,
Which versions of PostGIS are you using? (SELECT postgis_full_version()).
If it's earlier than 1.2.1, it sounds like you could be hitting the GiST
index bug documented here:
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/documentation/manual-svn/release_notes.html#id2692480">http://postgis.refractions.net/documentation/manual-svn/release_notes.html#id2692480</a>.
HTH,
Mark.
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
David R Robison
Open Roads Consulting, Inc.
708 S. Battlefield Blvd., Chesapeake, VA 23322
phone: (757) 546-3401
e-mail: <a class="moz-txt-link-abbreviated" href="mailto:drrobison@openroadsconsulting.com">drrobison@openroadsconsulting.com</a>
web: <a class="moz-txt-link-freetext" href="http://openroadsconsulting.com">http://openroadsconsulting.com</a>
blog: <a class="moz-txt-link-freetext" href="http://therobe.blogspot.com">http://therobe.blogspot.com</a>
book: <a class="moz-txt-link-freetext" href="http://www.xulonpress.com/book_detail.php?id=2579">http://www.xulonpress.com/book_detail.php?id=2579</a>
This e-mail communication (including any attachments) may contain confidential and/or privileged material intended solely for the individual or entity to which it is addressed. If you are not the intended recipient, you should immediately stop reading this message and delete it from all computers that it resides on. Any unauthorized reading, distribution, copying or other use of this communication (or its attachments) is strictly prohibited. If you have received this communication in error, please notify us immediately.
</pre>
</body>
</html>