[fdo-internals] RE: Defects in PostGIS provider
mateusz at loskot.net
Tue Sep 11 10:53:27 EDT 2007
Haris Kurtagic wrote:
> FDO on general "tier" doesn't have any relationships or integrity
> constrains checks.
It wasn't clear to me.
> As it is now in most provider's Open Source one they are just
> exposing RDBMS functionality in generalized way. And if RDBMS allow
> to drop table (one or few of them) with data in it than I think it is
> ok for provider to do so. Data integrity is checked by RDBMS itself.
Yes, that's how it works in PostGIS too.
> If some provider has his own constraints and integrity checks on top
> of RDBMS than it is up to that provider how will react to delete
> request. In general I think FDO provider shouldn't try to be smarter
> than RDBMS except when it is really adding some value to it.
This is interesting. I think it convinces me to second this idea.
In PostGIS, user should expect exception on violation of internal db
constraints, so perhaps Haris' concept could work as a general rule for
FDO providers for DBMS?
More information about the fdo-internals