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

Kenneth Skovhede, GEOGRAF A/S ks at geograf.dk
Tue Jul 8 03:25:43 EDT 2008


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
>   


More information about the fdo-internals mailing list