[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:

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