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

Bruno Scott bscott at geomapgis.com
Tue Jul 8 04:19:52 EDT 2008

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?


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

View this message in context: http://www.nabble.com/primary-key-on-views-for-rdbms-providers--tp18257773p18334206.html
Sent from the FDO Internals mailing list archive at Nabble.com.

More information about the fdo-internals mailing list