[postgis-users] RE: UDig and PostGIS

[Markus Schaber]

Hi, Carl & Johan,


Carl Anderson wrote:

> All geotools based software have the limitation you describe, and a few
> more.  The "fix" will require some changes to Geotools as as a couple to
> UDIG.
> 
> In the interim make sure that
>   you login to the database with the same name as the schema containing
> the geometry table
>   you have not changed postgresql.conf's parameter
>               search_path = '$user,public'    there is a
> geometry_columns table in the schema
>   there are no other tables in any other schema (database wide) that
> match your geometry table's names.

In recent PostgreSQL releases, you can also issue the command

ALTER USER blubb SET search_path TO blah, blubb, public;

with "blah, blubb, public" being a comma separated list of schemas where
you have your tables in. This will set the search_path appropriately for
all future connections of this user.

Schabi