[postgis-users] Shp2pgsql load error
strk at refractions.net
strk at refractions.net
Wed May 25 06:47:10 PDT 2005
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;
> >
More information about the postgis-users
mailing list