NEWS

PostGIS 1.1.7
2007/01/31

	- Fixed "function XXXXX returned NULL" error when creating a
          GiST index on a geometry column containing lots of NULLs
        - JDBC: - Fixed classpath problems with GCJ
                - Fixed pgjdbc 8.2 compatibility, losing support for
                  jdk 1.3 and older.
	- Fixed build issues with older versions of GEOS and gcc

PostGIS 1.1.6
2006/11/02

	- fixed CAPI change that broke 64-bit platforms
	- use Z ordinate in reprojections
	- spatial_ref_sys.sql updated to EPSG 6.11.1 
        - Simplified Version.config infrastructure to use a single
          pack of version variables for everything.
        - Include the Version.config in loader/dumper USAGE messages
        - Replace hand-made, fragile JDBC version parser with Properties
        - Fixed setSRID() bug in JDBC, thanks to Thomas Marti
        - loader/dumper: fixed regression tests and usage output


PostGIS 1.1.5
2006/10/13
	- Java:
	  - Removed obsolete synchronization from Jts code.
	  - fixed nullpointer Exception in Geometry.equals() method
          - Added EJB3Spatial.odt to fulfill the GPL requirement of
            distributing the "preferred form of modification"
	- Added -S option for non-multi geometries to shp2pgsql
	- Updated heavily outdated README files for shp2pgsql/pgsql2shp by 
	  merging them with the manpages.
	- Fixed MingW link error that was causing pgsql2shp to
	  segfault on Win32 when compiled for PostgreSQL 8.2

PostGIS 1.1.4
2006/09/27
	- Fixed support for PostgreSQL 8.2
	- Fixed bug in collect() function discarding SRID of
	  input
	- Added SRID match check in MakeBox2d and MakeBox3d
	- Fixed regress tests to pass with GEOS-3.0.0
	- Improved pgsql2shp run concurrency.
	- Java:
		- reworked JTS support to reflect new upstream
		  JTS developers' attitude to SRID handling.
		  Simplifies code and drops build depend on GNU trove.
		- Added EJB2 support generously donated by the
		  "Geodetix s.r.l. Company" http://www.geodetix.it/
		- Added EJB3 tutorial / examples donated by
		  Norman Barker <nbarker@ittvis.com>
		- Reorganized java directory layout a little.

PostGIS 1.1.3
2006/06/30

	- NEW Long Transactions support.
	- Can run the regress tests with 'make check' now.
	- New regress test support for loader/dumper.
	- BUGFIX in pgsql2shp successful return code.
	- BUGFIX in shp2pgsql handling of MultiLine WKT.
	- BUGFIX in affine() failing to update bounding box.
	- WKT parser: forbidden construction of multigeometries with
	  EMPTY elements (still supported for GEOMETRYCOLLECTION).
	- Added --with-proj-libdir and --with-geos-libdir configure
	  switches.
	- JDBC:
	    - Improved regression tests: MultiPoint and scientific ordinates
	    - Fixed some minor bugs in jdbc code
	    - Added proper accessor functions for all fields in preparation of
	      making those fields private later
	- Support for build Tru64 build.
	- Use Jade for generating documentation.
	- NEW DumpRings() function.
	- BUGFIX in distance(poly,poly) giving wrong results.
	- NEW AsHEXEWKB(geom, XDR|NDR) function.
	- Don't link pgsql2shp to more libs then required.
	- Initial support for PostgreSQL 8.2.

PostGIS 1.1.2
2006/03/30

	- Regress tests can now be run *before* postgis intallation
	- BUGFIX in SnapToGrid() computation of output bounding box
	- More portable ./configure script
	- Changed ./run_test script to have more sane default behaviour
	- Fixed support for 64bit archs
	- jdbc2 SRID handling fixes in JTS code
	- New affine() matrix transformation functions
	- New rotate{,X,Y,Z}() function 
	- Old translating and scaling functions now use affine() internally
	- BUGFIX in EnforceRHR() 
	- Embedded access control in estimated_extent() for builds against
	  pgsql >= 8.0.0

PostGIS 1.1.1
2006/01/23

	- Source code cleanups
	- Solaris 2.7 and MingW support improvements
	- added NumInteriorRing() alias due to OpenGIS ambiguity
	- BUGFIX in geometrycollection handling of GEOS-CAPI connector
	- BUGFIX in line_locate_point()
	- Fixed handling of postgresql paths
	- Fixed a premature exit in postgis_restore.pl 
	- BUGFIX in line_substring()
	- New Z and M interpolation in line_substring()
	- New Z and M interpolation in line_interpolate_point()
	- Added support for localized cluster in regress tester

PostGIS 1.1.0
2005/12/21

	- New functions:
		- scale() and transscale() companion methods to translate()
		- line_substring() 
		- line_locate_point()
		- M(point) 
		- LineMerge(geometry) 
		- shift_longitude(geometry) 
		- azimuth(geometry) 
		- locate_along_measure(geometry, float8) 
		- locate_between_measures(geometry, float8, float8) 
		- SnapToGrid by point offset (up to 4d support)
		- BuildArea(any_geometry) 
		- OGC BdPolyFromText(linestring_wkt, srid) 
		- OGC BdMPolyFromText(linestring_wkt, srid)
		- RemovePoint(linestring, offset)
		- ReplacePoint(linestring, offset, point)

	- Bug fixes:
		- Fixed memory leak in polygonize()
		- Fixed bug in lwgeom_as_anytype cast funcions
		- Fixed USE_GEOS, USE_PROJ and USE_STATS elements
		  of postgis_version() output to always reflect
		  library state.

	- Function semantic changes:
		- SnapToGrid doesn't discard higher dimensions
		- Changed Z() function to return NULL if requested
	  	  dimension is not available

	- Peformance improvements:
		- Much faster transform() function, caching proj4 objects
		- Removed automatic call to fix_geometry_columns() in
	  	  AddGeometryColumns() and update_geometry_stats()

	- jdbc2 works:
		- Makefile improvements
		- JTS support improvements
		- Improved regression test system
		- Basic consistency check method for geometry collections
		- Support for (Hex)(E)wkb
		- Autoprobing DriverWrapper for HexWKB / EWKT switching
		- fix compile problems in ValueSetter for ancient jdk releases.
		- fix EWKT constructors to accept SRID=4711; representation
		- added preliminary read-only support for java2d geometries
	
	- Other new things:
		- Full autoconf-based configuration, with
		  PostgreSQL source dependency relief
		- GEOS C-API support (2.2.0 and higher)
		- Initial support for topology modelling
		- Debian and RPM specfiles
		- New lwpostgis_upgrade.sql script

	- Other changes:
		- JTS support improvements
		- Stricter mapping between DBF and SQL integer and
		  string attributes
		- Wider and cleaner regression test suite
		- old jdbc code removed from release
		- obsoleted direct use of postgis_proc_upgrade.pl
		- scripts version unified with release version

PostGIS 1.0.6
2005/12/06
	- Fixed palloc(0) call in collection deserializer (only gives
	  problem with --enable-cassert)
	- Fixed bbox cache handling bugs
	- Fixed geom_accum(NULL, NULL) segfault
	- Initial support for postgresql 8.2
	- Fixed segfault in addPoint()
	- Fixed short-allocation in lwcollection_clone()
	- Fixed bug in segmentize()
	- Added missing SRID mismatch checks in GEOS ops
	- Fixed bbox computation of SnapToGrid output

PostGIS 1.0.5
2005/11/25
	- New "Reporting Bugs" chapter in manual
	- Segfault fix in shp2pgsql (utf8 encoding)
	- Fixed computation of null values fraction in analyzer
	- Fixed return code of shp2pgsql
	- Fixed handling of trailing dots in dbf numerical attributes
	- Schema aware postgis_proc_upgrade.pl, support for pgsql 7.2+
	- Fixed a small bug in the getPoint4d_p() low-level function
	- Fixed memory alignment problems
	- Speedup of serializer functions
	- Bug fix in force_4d, force_3dm and force_3dz functions

PostGIS 1.0.4
2005/09/09
	- Memory leak plugged in GiST indexing
	- Segfault fix in transform() handling of proj4 errors
	- Fixed some proj4 texts in spatial_ref_sys (missing +proj)
	- GiST indexing cleanup
	- Loader: fixed string functions usage, reworked NULL objects check,
	  fixed segfault on MULTILINESTRING input.
	- Fixed bug in MakeLine dimension handling
	- Looser syntax acceptance in box3d parser
	- Documentation improvements
	- More robust selectivity estimator
	- Minor speedup in distance()
	- Minor cleanups
	- Fixed bug in translate() corrupting output bounding box
	- Initial implementation of postgis_proc_upgrade script

PostGIS 1.0.3
2005/08/08
	- Severe bugfix in lwgeom's 2d bounding box computation
	- Bugfix in WKT (-w) POINT handling in loader
	- Bugfix in dumper on 64bit machines
	- Bugfix in dumper handling of user-defined queries 
	- Bugfix in create_undef.pl script
	- Small performance improvement in canonical input function
	- Minor cleanups in loader
	- Support for multibyte field names in loader
	- Improvement in the postgis_restore.pl script
	- New rebuild_bbox_caches.pl util script

PostGIS 1.0.2
2005/07/04
	- Fault tolerant btree ops
	- Memory Leak fix in pg_error
	- Rtree index fix. See:
	  http://archives.postgresql.org/pgsql-hackers/2005-06/msg01108.php
        - Initial support for postgresql 8.1dev
	- Cleaner build scripts: avoided mix of CFLAGS and CXXFLAGS
	- NEW -I switch for pgsql2shp (GiST index)

PostGIS 1.0.1
2005/05/24
	- BUGFIX in shp2pgql escape functions
	- BUGFIX in 3d computation of lenght_spheroid
	- better support for concurrent postgis in multiple schemas
	- documentation fixes
	- BUGFIX in join selectivity estimator returning invalid estimates (>1)
	- jdbc2: compile with "-target 1.2 -source 1.2" by default
	- NEW support for custom createdb options in postgis_restore.pl
	- NEW -k switch for pgsql2shp
	- BUGFIX in pgsql2shp attribute names unicity enforcement
	- BUGFIX in Paris projections definitions
	- postgis_restore.pl cleanups

PostGIS 1.0.0
2005/04/19
	- NEW manual pages for loader/dumper
	- NEW shp2pgsql support for old (HWGEOM) postgis versions
	- NEW -p flag for shp2pgsql
	- BUGFIX in transform() releasing random memory address
	- BUGFIX in force_3dm() allocating less memory then required
	- NEW chapter about OGC compliancy enforcement
	- BUGFIX in shp2pgsql escape of values starting with "'" or "\t" 
	- NEW autoconf support for JTS lib
	- BUGFIX in estimator testers (support for LWGEOM and schema parsing)
	- BUGFIX in join selectivity estimator (defaults, leaks, tuplecount, sd)

PostGIS 1.0.0RC6
2005/03/30
	- BUGFIX dumper 64bit
	- BUGFIX in multi()
	- BUGFIX in postgis_restore.pl script
	- early return [when noop] from multi()
	- dropped {x,y}{min,max}(box2d) functions

PostGIS 1.0.0RC5
2005/03/25
	- small build scripts refinements
	- BUGFIX in box3d computation (yes, another!)
	- BUGFIX in estimated_extent()
        - additional performance tips documented

PostGIS 1.0.0RC4
2005/03/18
	- early return from force_collection
	- segfault fix in geom_accum()
	- consistency check fix in SnapToGrid()
	- jdbc2: code cleanups, Makefile improvements
	- FLEX & YACC variables set *after* pgsql Makefile.global
	  is included and only if the pgsql *stripped* version
	  evaulates to the empty string
	- added already generated parser in release
	- build scripts refinements
	- MultiLine handling BUG fix in loader and dumper
	- improved version handling, central Version.config
        - added distance_sphere function 
	- subselects support in selectivity estimator 
	- bug fixes for 64bit architectures
	- bugfix in loaded, skipping all but first hole of polygons.
	- changed get_proj4_from_srid implementation to use plpgsql
	  instead of sql to workaround a pgsql80x bug.
	- box2d output changed back to 15 significant digits
	- BUGFIX in box3d computation function with collections
	- improvements in postgis_restore.pl

PostGIS 1.0.0RC3
2005/02/24
	- transform(): missing SRID bugfix, better error handling
	- jdbc2: small patches, box2d/3d tests, revised docs and license.
	- jdbc2: bug fix and testcase in for pgjdbc 8.0 type autoregistration
	- few changes in autoconf 
	- reduced precision of box2d output.
	- some functions made IMMUTABLE from STABLE,
	  for performance improvement
	- new performance tips chapter in manual
	- BUILDDATE extraction made more portable
	- fixed bogus 72 index bindings
	- prefixed DEBUG macros with PGIS_ to avoid clash with pgsql one
	- fixes in probe_geometry_columns() to work with PG72 and support
	  multiple geometry columns in a single table
	- fixed spatial_ref_sys.sql to avoid vacuuming the whole database.
	- jdbc2: Removed use of jdk1.4 only features to enable build with 
	  older jdk releases.
	- jdbc2: Added support for building against pg72jdbc2.jar
	- documentation updates: pgsql72 requirement, lwpostgis.sql
	- memory alignment handling
	- fixed bug in force_collection causing mapserver connector
	  failures on simple (single) geometry types.
	- jdbc2: updated and cleaned makefile
	- plugged a leak in GEOS2POSTGIS converter
	- jdbc2: added BETA support for jts geometry classes
	- jdbc2: Skip known-to-fail tests against older PostGIS servers.
	- jdbc2: Fixed handling of measured geometries in EWKT.
	- Reduced memory usage by early releasing query-context palloced one.
	- Added bool::text cast in lwpostgis.sql
	- bug fix in GeometryFromText() missing to add a bbox cache.
	- spatial_ref_sys: changed Paris entries to match the ones
	  distributed with 0.x.

PostGIS 1.0.0RC2
2005/01/26
	- More correct STABLE, IMMUTABLE, STRICT uses in lwpostgis.sql
	- GEOMETRYCOLLECTION(EMPTY) syntax support for backward compatibility
	- faster and more robust loader (both i18n and not)
	- faster binary outputs
	- bug fix in pointarray box3d computation
	- initial autoconf script
	- bug fix in distance_spheroid definition
	- stricter OGC WKB constructors
	- stricter OGC WKT constructors
	- bug fix in transform() missing to update bbox cache
	- LWGEOM aware JDBC driver (jdbc2)

PostGIS 1.0.0RC1
2005/01/13

- New Things
  - Objects are all now "lightweight" with a smaller disk
    and index representation. Large databases should see a moderate
    to large performance increase.
  - Objects now have a hexidecimal canonical representation.
    To see a "user friendly" version of the objects use the
    AsText() function.
  - The loader and dumper use the hexidecimal canonical representation,
    so coordinate drift due to floating point string parsing is now
    eliminated.
  - New functions: UpdateGeometrySRID(), AsGML(), SnapToGrid(),
    ForceRHR(), estimated_extent(), Accum().
  - Vertical positioning operators.
  - Geometry constructors/editors.
  - Coordinate dimensions handling (up to 4d).
  - API.
  - Join selectivity.
- Bug Fixes
  - Numerous small fixes.

PostGIS 0.9.0
2004/09/10

- New Things
  - GEOMETRY_COLUMNS management functions
    - fix_geometry_columns(), probe_geometry_columns()
  - Support for PgSQL 8.0 / Support for Win32
  - Support for GEOS 2.0
- Bug Fixes
  - Schema support in shp2pgsql/pgsql2shp improved
  - Spatial index estimator improved
  - Build system streamlined


PostGIS 0.8.2
2004/05/27

- New Things
  - PgSQL 7.5 Support
  - Integrated PgSQL 7.5 statistics rathering
  - Improved schema support
  - Optional experimental lightweight geometries (LWGEOM)
    - Faster performance
    - Lower disk usage
  - Multi() function to create MULTI* geometries
  - line_interpolate_point() function for linear referencing
- Bug Fixes
  - Minor memory leaks gone
  - Solaris support cleaner
  - shp2pgsql/pgsql2shp more corner cases fixed
  

PostGIS 0.8.1
2004/01/12

- New Things
  - Schema support in AddGeometryColumn and loader/dumper
- Bug Fixes
  - Memory fixes
  - GEOS translation fixes


PostGIS 0.8.0
2003/11/24

- New Things
  - Support for PostgreSQL 7.4
  - Support for all OpenGIS SFSQL functions (requires GEOS)
    - Contains()
    - Within()
    - GeomUnion()
    - Intersection()
    - Buffer()
    - and many more...!
  - Includes OpenGIS conformance tests
  - Passes all OpenGIS conformance tests
  - Spatial aggregate functions
    - GeomUnion() 
    - Collect()
- Bug Fixes
  - shp2pgsql/pgsql2shp
    - Numerous special cases in rings and 
      attributes repaired
  - Some OpenGIS conformance changes


PostGIS 0.7.5
2003/04/08

- Bug Fixes
  - shp2pgsql 
    - Z coordinate handling
    - M coordinate handling
    - Ring handling fixed in some cases
    - Support for large numbers in attribute tables
  - Some obscure operators fixed
  - Some cygwin build improvements


PostGIS 0.7.4
2003/02/12

- Bug Fixes
  - Several shp2pgsql enhancements and bugs.
  - Cleaner compile, fewer warnings.
  - Better undef support.
  - Fixed stateplane/feet proj definitions.
- New Things
  - Support for PostgreSQL 7.3
  - Optional spatial index selectivity system


PostGIS 0.7.3
2002/09/05

- Bug Fixes
  - Stupid bug in .sql install script breaks install for
    many. Squashed. New release needed.
  - Automatic version detection for appropriate GiST bindings
  - postgis_transform now supports box3d types as well as geometry


PostGIS 0.7.2
2002/09/01

- Bug Fixes
  - Numerous subtle bugs fixed in pgsql2shp and shp2pgsql DBF and
    SHP file handling
  - Some pgsql 7.3 preparations
  - Patch to truly_inside() corner case
  - Updates to the ~ and @ operators
  - Update to translate() function to also translate bbox


PostGIS 0.7.1
2002/05/14

- Bug Fixes
  - PgSQL 7.2 RTree-over-GIST bug fix. Rare data cases
    caused index building to fail.
  - Carriage returns removed from source code. Were
    causing compilation failures.
  - collect() now returns simplest homogeneous type
    being aggregated (e.g.M ULTIPOLYGON for collect(*POLYGON))


PostGIS 0.7.0
2002/05/04

- New Things
  - transform() function provides coordinate reprojection 
    using proj4 library
  - spatial_ref_sys.sql has a complete set of proj4 
    definitions for each EPSG coordinate system
  - support for PostgreSQL 7.2 GiST index API
  - refactoring of source code to separate index support
    functions from other functions
  - max_distance() function
  - distance_spheroid() function
  - collect() aggregate function
  - xmin(),ymin(),zmin(),xmax(),ymax(),zmax() functions
- Bug Fixes
  - transform() more graceful when grid shifts are missing
  - setsrid() made cachable
  - patches to loader/dumper


PostGIS 0.6.2
2001/11/07

- New Things
  - spatial_ref_sys.sql complete set of SRID and WKT
  - generate postgis_undef.sql automatically at build
- Bug fixes
  - Memory problem in shp2pgsql
  - Compilation problems with shp2pgsql


PostGIS 0.6.1
2001/10/15

- Bug fixes
  - Cygwin compilation fix
  - Improved getopts handling in utility programs
  - Text casting fixes


PostGIS 0.6
2001/09/19

- New functions
  - postgis_version()
    Return the PostGIS version number.
  - find_srid(<db/schema>::varchar, <table>::varchar, <column>::varchar)
    Return the SRID number for a particular column of a database.
  - AddGeometryColumn(<db/schema>::varchar, <table>::varchar,
      <column>::varchar, <srid>::integer, <type>::varchar, 
      <dimension>::integer)
    Appends a geometry column to an existing table and updates the
    metadata tables appropriately.
  - DropGeometryColumn(<db/schema>::varchar, <table>::varchar, 
      <column>::varchar)
    Removes a geometry column from an existing spatial table.
  - Distance(<geom1>::geometry, <geom2>::geometry)
    Returns the cartesian distance between two geometries.
  - AsText(<geom>::geometry)
    Returns the OGC well-known text version of the geometry.
  - SRID(<geom>::geometry)
    Returns the integer SRID of the geometry.
  - GeometryFromText(<geom>::varchar, <srid>::integer)
    Creates a geometry object given the OGC well-known text and a valid
    SRID.
  - SetSRID(<geom>::geometry)
    Sets the SRID of a geometry to a particular value.
  - IsClosed(<geom>::geometry)
    Returns true of first and last points of geometry are coincident.
  - StartPoint(<geom>::geometry)
    Returns the first point of a geometry.
  - EndPoint(<geom>::geometry)
    Returns the last point of a geometry.
  - Centroid(<geom>::geometry)
    Returns the centroid of a geometry.
- More OpenGIS SFSQL compatibility
  - SPATIAL_REF_SYS table
  - GEOMETRY_COLUMNS table
  - SRID integrity checking
- Better Mapserver compatibility
- Minor fixes/changes
  - Support for WKB in the tables
  - Miscellaneous bug fixes
  - Placeholders for precision grid


PostGIS 0.5
2001/07/20

- New functions
  - Dimension()
  - GeometryType()
  - Envelope() 
  - X(), Y(), Z()
  - NumPoints()
  - PointN()
  - ExteriorRing()
  - NumInteriorRings()
  - InteriorRingN()
  - NumGeometries()
  - GeometryN()
  - Length_Spheroid()
  - Length3D_Spheroid()
  - AsBinary() + XDR and NDR variants
  - force_collection()
- Removed functions
  - wkb_ndr()
  - wkb_xdr()
- New Objects
  - SPHEROID(<NAME>,<SEMIMAJOR AXIS>,<INVERSE FLATTENING>)
    To be used with the length_spheroid functions for accurate
    length calculations on lat/lon data.
- Minor bug fixes
- Internal Functions
  - Extra constructors to make geometry manipulation easier
- Structural Reorganization
  - Broke postgis.c up into four new files
    postgis_debug.c -- debugging functions
    postgis_fn.c -- generic functions (like length())
    postgis_ops.c -- operators and indexing functions
    postgis_inout.c -- type support functions and data conversion functions


PostGIS 0.2
2001/06/19

- New functions
  - extent()
  - force_2d()
  - force_3d()
  - wkb_xdr()
  - wkb_ndr()
  - translate()
- Fixes
  - Cygwin compilation (Norman Vine)
  - i386 byte alignment fixed
  - 'VACUUM ANALYZE' fixed
- Other
  - documentation in docbook xml
  - example program for WKB access
  - removed 'make test' until we can get regression
    working more cleanly


PostGIS 0.1
2001/05/25

- Initial release!
- 'geometry' and 'box3d' types.
- Parsing routines for all possible geometries in OGIS text format 
  (POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON,
  GEOMETRYCOLLECTION).
- Output routines for all possible geometries in OGIS text format.
- area2d(), area3d()
- length3d(), length3d()
- perimeter2d(), perimeter3d()
- truely_inside()
- rtree index support functions
- gist index support functions