[postgis-users] pgsql2shp error

Adam Eskreis aeskreis at gmail.com
Sat Oct 22 10:56:28 PDT 2011


Are you sure that the projection you are using is in your spatial_ref_sys
table?

On Sat, Oct 22, 2011 at 1:46 PM, Christian Jauvin <cjauvin at gmail.com> wrote:

> Yes:
>
> createlang: language "plpgsql" is already installed in database
>
> I thought that this was required for a PostGIS-enabled database anyway..?
>
> It is a very straightforward database: two tables imported from
> shapefiles with shp2pgsql:
>
> # \dt
>                 List of relations
>  Schema |         Name         | Type  |   Owner
> --------+----------------------+-------+-----------
>  public | dmti_qc_streets_2008 | table | christian
>  public | geometry_columns     | table | christian
>  public | sdr_2001             | table | christian
>  public | spatial_ref_sys      | table | christian
>
>
>
>
> On Sat, Oct 22, 2011 at 12:58 PM, p valdes <p.valdes334 at gmail.com> wrote:
> > have you do this?
> >
> > createlang plpgsql mydatabase
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111022/2af99799/attachment.html>


More information about the postgis-users mailing list