[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