[postgis-users] Shp2pgsql load error

[strk at refractions.net]

On Wed, May 25, 2005 at 09:43:44AM -0400, Kralidis,Tom [Burlington] wrote:
> 
> 
> > -----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.

Can you isolate a single INSERT generating the error ?

--strk;

> 
> ..Tom
> 
> 
> > --strk;
> >