[postgis-users] Shp2pgsql load error

[Kralidis,Tom [Burlington]]

> -----Original Message-----
> From: Sandro Santilli [mailto:strk at refractions.net] 
> Sent: Wednesday, 25 May, 2005 09:20
> To: Kralidis,Tom [Burlington]
> Cc: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] Shp2pgsql load error
> 
> 
> 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
> 

I have updated using the "old" procedure.  Now:


devgeodb=# select postgis_full_version();
                                          postgis_full_version
------------------------------------------------------------------------
---------------------------------
 POSTGIS="1.1.0CVS" GEOS="2.1.1" PROJ="Rel. 4.4.9, 29 Oct 2004"
USE_STATS DBPROC="0.3.0" RELPROC="0.3.0"
(1 row)

..and am getting the same error messages when trying to insert ISO8859-1
data into a UNICODE database.  PGCLIENTENCODING is defined as Latin1.

..Tom


> --strk;
>