[postgis-users] RE: UDig and PostGIS
Carl Anderson
carl.anderson at vadose.org
Tue Dec 6 17:42:49 PST 2005
Markus Schaber wrote:
>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.
>
>
>
Thanks,
But remember that table name collision can occur during the field
definitions pass....... in a ABEND kind of way.
C.
>Schabi
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
More information about the postgis-users
mailing list