[Gvsig_english] Problems with PostGIS layers

[George Silva]

Thank you very much. I will look for that.

Perhaps a constant vacuum or reindex of the geometry_columns should work?

I will check that tomorrow as soon as i get to the office!

On Thu, May 22, 2008 at 8:01 PM, Fran <fpenarru at gmail.com> wrote:

> 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
>>
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at runas.cap.gva.es
> http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20080522/39efccce/attachment.htm