[fdo-internals] RE: Defects in PostGIS provider

Mateusz Loskot 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?

Mateusz Loskot

More information about the fdo-internals mailing list