[udig-devel] How can I add Layers from PostGIS?

[오명운]

Thanks a lot...
Your answer just pointed out the problem, lwpostgis.sql was not installed.

And one more... In win32 version, the location of lwpostgis.sql is
"<postgreSQL_Installation_dir\share\contrib"

Thank you again. ^^
Have a nice day.


2006/9/8, Cory Horner <chorner at refractions.net>:
>
> 오명운 wrote:
>
> > I installed PostgreSQL 8.1.4, PostGIS 1.1.3, u-Dig 1.0.6 on my
> > WindowsXP computer.
> > In u-Dig,
> > I tried to add layers from PostGIS using 'File>New>New Layer>PostGIS'.
> > I typed the PostGIS Server Information(Host, Username, Password,
> > Database, Schema) and clicked 'Next' button in 'Add layers to Map'
> > pop-up window.
> > Then u-Dig shows Error messages like below.
> > ------
> > org.geotools.data.DataSourceException: ERROR: function
> > postgis_version() does not exist
>
> Hello!
>
> It sounds like PostGIS isn't properly set up, as it cannot find the
> postgis_version function. Options are to fire up the pgAdmin tool that
> came with postgres, or use the psql command line, and look at your
> database to see if it has functions properly installed. Chances are the
> lwpostgis.sql has not been imported; note that your have to
> postgis-enable *each* database you intend to use. More details here
> (starting at point #5):
>
> http://postgis.refractions.net/docs/ch02.html#PGInstall
>
> Cheers,
> Cory.
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.refractions.net/pipermail/udig-devel/attachments/20060908/78cd1ef4/attachment.html