[Gvsig_english] can gvsig connect to distant postgis database

[Francisco José Peñarrubia]

Hi Michael.

I think the reason of this problem may be the ID you have chosen. Did 
you use gid?. Selection in postgis layers will fail if the field ID is 
not what gvSIG expects.
Anyway, we will have a look.

Thankis.

Michael Fecht escribió:
> Thanks for your answers.
>
> I tried to edit a line layer (type: LINESTRING) in QGIS and it works.
> Then I tried again in gvSIG, but it 's not possible to select any 
> existing line, so it's is not possible to edit the geometry.
>
> When iI trie to edit the attributes of the layer, it seems to work but 
> when i want to save it I get the following error:
>
> com.iver.cit.gvsig.fmap.edition.EditionException: 
> org.postgresql.util.PSQLException: ERROR: new row for relation 
> "ttmpwegsegment" violates check constraint "enforce_geotype_the_geom"
>
>
> Here there are the system infomations:
>
> - the host is an internal network server running with ubuntu server 
> 5.10 (kernel 2.6.15)
> - postgres version: 8.1.4
> - postgis: 1.1.3
>
> - On the client I have installed Mandriva 2006.
>
> Michael
>
>
> jaume dominguez faus schrieb:
>> I agree with Giovanni. Probably, this problem comes from the grants 
>> or permissions configured in the database. Postgres has lots of 
>> security configuration options either for network issues (before 
>> connected) and for data access (once connected). If you find that you 
>> can edit normally with other tool but you cannot do so with gvSIG 
>> then I'd ask you to report us.
>>
>> host?
>> version?
>> os?
>> ...
>>
>> Salut
>>
>> En/na G. Allegri ha escrit:
>>
>>> Quite a strange behavior. Why should it not be able to edit postgis 
>>> layers in remote server, when it's possible in a local one? The 
>>> driver should be transparent to the connection url (server). Is'n it 
>>> just a privileges/grants problem? I never tried on remote server... 
>>> but I would need thi feature!!!
>>> -- 
>>> Giovanni
>>>
>>> 2007/6/11, Michael Fecht <fecht at grid-it.at <mailto:fecht at grid-it.at>>:
>>>
>>>     Hi Price,
>>>
>>>     I tried the gvSIG connection to a PostGIS database on an other
>>>     Server in
>>>     our internal network. Important for the connection is that port
>>>     5432 is
>>>     open and you are allowed to connect to postgres (check 
>>> pg_hba.conf).
>>>
>>>     It is possible to view the PostGIS layers, but it's not possible
>>>     to edit
>>>     them (Geometry).
>>>
>>>     Michael
>>>
>>>     Price NJANDA schrieb:
>>>     >
>>>     > Hi list
>>>     > Did someone tested a gvSIG connexion to a distant PostGIS 
>>> database?
>>>     > What conclusion ?
>>>     > I would appreciate any comment.
>>>     >
>>>     > Price
>>>     > _______________________________________________
>>>     > Gvsig_internacional mailing list
>>>     > Gvsig_internacional at runas.cap.gva.es
>>>     <mailto:Gvsig_internacional at runas.cap.gva.es>
>>>     > http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>>>
>>>     --
>>>     Mag. Michael Fecht
>>>
>>>     GRID-IT Gesellschaft für angewandte Geoinformatik mbH
>>>     Technikerstraße 21a, A-6020 Innsbruck
>>>     web  www.grid-it.at <http://www.grid-it.at>
>>>     fax +43 (0)512 507 4869
>>>
>>>     tel +43 (0)512 507 4862
>>>     mail fecht at grid-it.at <http://grid-it.at>
>>>     -----------------------------------------------------
>>>     Abonnieren Sie unseren Newsletter unter
>>>        http://www.grid-it.at/home/service/newsletter/
>>>     <http://www.grid-it.at/home/service/newsletter/>
>>>     _______________________________________________
>>>     Gvsig_internacional mailing list
>>>     Gvsig_internacional at runas.cap.gva.es
>>>     <mailto:Gvsig_internacional at runas.cap.gva.es>
>>>     http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>>>
>>>
>>> ------------------------------------------------------------------------ 
>>>
>>>
>>> _______________________________________________
>>> Gvsig_internacional mailing list
>>> Gvsig_internacional at runas.cap.gva.es
>>> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>>>  
>>>
>>
>>
>