[postgis-users] RE: UDig and PostGIS
Markus Schaber
schabi at logix-tt.com
Tue Dec 6 06:34:45 PST 2005
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
More information about the postgis-users
mailing list