[Gvsig_english] Problems with PostGIS layers

[Fran]

Hi George.

Every time gvSIG loads a PostGIS layer, it searchs the corret register 
in table "GEOMETRY_COLUMNS". This way, it can read wich geometry column 
contains the geometry, and wich coordinate referencing system is using 
the table.
Please, check that all your tables (or views) have their correspondant 
register in this table.

Hope this helps.

Fran.

George R. C. Silva escribió:
> Well, i don´t know what it was. I had no uppercase letters.
>
> I redid my work, and now works fine, but i didnt do anything different!
>
> Any1 else experienced this kind of problem?
>
> Its very annoying, and kinda of a serious issue (i guess - perhaps im 
> doing something wrong?). Everytime (some time ago), when i rendered 
> postgis layers from spatial function (like insert into x st_buffer()) 
> gvsig wouldnt load my layers. either.
>
> Thank you Marcus for your help.
>
> Att.
>
> George
>
>
> Marcus C. England escreveu:
>> I had that issue before, and if I recall correctly, it was because 
>> gvSIG won't load PostGIS layers with column names that have uppercase 
>> letters. I had no problems with that for awhile because I was 
>> (formerly) using qGIS to upload data to PostGIS and it converted 
>> uppercase column names to lowercase. A qGIS update changed that 
>> behavior and left uppercase letters in. Those layers would not load 
>> in gvSIG. Looking just now at several layers uploaded to PostGIS from 
>> within gvSIG yesterday, the shapefiles had uppercase column names and 
>> gvSIG converted them to lower case.
>>
>> -Marcus
>>
>> George R. C. Silva wrote:
>>> Hello everyone.
>>>
>>> Sometimes, GvSIG wont let me add PostGIS layers, even tough they 
>>> have a geometry column and gid.
>>>
>>> These layers all open in QGis but wont open in gvsig.
>>>
>>> All the layers have apropriate spatial constraints.
>>>
>>> Can anyone give me a hand?
>>>
>>> Thanks
>>>
>>> George Silva
>>> _______________________________________________
>>> Gvsig_internacional mailing list
>>> 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
>>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at runas.cap.gva.es
> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional