[fdo-internals] RE: Defects in PostGIS provider

[Haris Kurtagic]

FDO on general "tier" doesn't have any relationships or integrity
constrains checks.
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.
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.

Haris

-----Original Message-----
From: fdo-internals-bounces at lists.osgeo.org
[mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Orest
Halustchak
Sent: Friday, August 24, 2007 2:27 PM
To: FDO Internals Mail List
Subject: RE: [fdo-internals] RE: Defects in PostGIS provider

Yes, our position was that removing a class definition from a data store
should be prevented if there is still data of that class in the data
store. You have to delete the data first, then you can remove the class
definition.

Thanks,
Orest.

-----Original Message-----
From: fdo-internals-bounces at lists.osgeo.org
[mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Mateusz
Loskot
Sent: Friday, August 24, 2007 8:20 AM
To: FDO Internals Mail List
Subject: Re: [fdo-internals] RE: Defects in PostGIS provider

Haris Kurtagic wrote:
> Hm, If I am looking in database behavior it would be normal to delete
>  class/table if data is in the class/table.
> 
> So in my opinion it is expected behavior to be able to delete class 
> regardless of data in it.

Haris,

I'm not sure if that would be safe.
Considering that a feature class is not always mapped to single table,
but may be mapped to N physical tables, deleting data along with table
is potentially unsafe for data integrity.

Cheers
-- 
Mateusz Loskot
http://mateusz.loskot.net
_______________________________________________
fdo-internals mailing list
fdo-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-internals

_______________________________________________
fdo-internals mailing list
fdo-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-internals