Postgres Pro
Downloads
Home   >   mailing lists

Null values in indexes - Mailing list pgsql-hackers

From Dann Corbit
Subject Null values in indexes
Date
Msg-id D90A5A6C612A39408103E6ECDD77B82920CEC5@voyager.corporate.connx.com
Whole thread Raw
Responses Re: Null values in indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
With 7.1.3, large indexes with null values allowed in one or more of the
columns would cause crashes.  (I have definitely seen this happen).

Here is a project that mentions repairs:
http://postgis.refractions.net/news/index.php?file=20020425.data

Have repairs been effected in 7.2?  Are they delayed until 7.3?

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: strange update problem with 7.2.1
Next
From: Tom Lane
Date:
Subject: Re: Polygons passed to poly_overlap have 0 pts when column is indexed using rtree