[fdo-internals] primary key on views for rdbms providers?

[Kenneth Skovhede, GEOGRAF A/S]

I don't think king.oracle works on views without setup in the helper table.

If it is possible to detect/guess the PK in any way, that would the
best solution IMO (less user action required).

The ability to override and otherwise setup the datasource is nice.
You could put it in a config document rather than a special table.
There are pros and cons for both I think.

Regards, Kenneth Skovhede, GEOGRAF A/S



Bruno Scott skrev:
> Yes it's true,
> But king.oracle can also work wihout this helper table!
> Does it support selection on views without the helper table?
>
> Do you think adding this king of helper table in the PostGIS provider is a
> good approach?
>
> Bruno
>
>
> Kenneth Skovhede, GEOGRAF A/S wrote:
>   
>> The Oracle provider does this with a special helper table:
>> http://www.sl-king.com/fdooracle/KingFdoClass.htm
>>
>> Regards, Kenneth Skovhede, GEOGRAF A/S
>>
>>
>>
>> Bruno Scott skrev:
>>     
>>> I'm facing a problem in the PostGIS provider when mapping a view to a
>>> feature
>>> class.
>>> How to determine wich column will serves as primary key.
>>> Is there a way in PostGIS to know wich one?
>>>
>>> And on a more general perspective, what if there is more than one primary
>>> key in the view's based tables? Is there a rule of thumb we could use?
>>>
>>> How did you manage to resolve this question in providers like
>>> Oracle,MySQL,SqlServer???
>>>
>>> When there is no primary key on a feature class, the selection in
>>> mapguide
>>> does not work!
>>>
>>> Thanks
>>> Bruno
>>>   
>>>       
>> _______________________________________________
>> fdo-internals mailing list
>> fdo-internals at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-internals
>>
>>
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-internals/attachments/20080708/4ad4e6af/attachment.html