[postgis-users] Shp2pgsql load error

[Kralidis,Tom [Burlington]]

UPDATE:

I did a fresh install of PostgreSQL 8.0.3 and PostGIS latest CVS (with
USE_ICONV=1).  This command:

/usr/local/pgsql/bin/shp2pgsql  -W ISO8859-1 wshed_p public.wshed_p |
/usr/local/pgsql/bin/psql -d devgeodb -U postgres

...works.  Gremlins.

..Tom

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of strk at refractions.net
> Sent: Wednesday, 25 May, 2005 09:47
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] Shp2pgsql load error
> 
> 
> 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;
> > > 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>