[postgis-users] Shp2pgsql load error

[Sandro Santilli]

On Wed, May 25, 2005 at 09:11:42AM -0400, Kralidis,Tom [Burlington] wrote:

[...]

> devgeodb=# select postgis_full_version();
>                              postgis_full_version
> ------------------------------------------------------------------------
> -------
>  POSTGIS="1.0.0" USE_STATS DBPROC="0.1.0" RELPROC="0.3.0" (needs proc
> upgrade)

The "(needs proc upgrade)" part is telling you that your upgrade procedure
was not performed correctly.

Postgis is a library and a set of definitions.
If you upgrade the library w/out upgrading the definitions, then
the final installation state is undefined.

Read the 'Upgrading' section in postgis manual and try with a cleanly
installed database:

http://postgis.refractions.net/docs/ch02.html#upgrading

--strk;