[fdo-internals] PostGIS ticket 106 question

[Bruno Scott]

So this meens that all these providers have a defect?
  Sdf 
  Shp 
  Autodesk Oracle 
  King Oracle 
  MySQL 
  Autodesk SqlServer 
Because they allow dropping table with data in it.
Bruno


Robert Fortin wrote:
> 
> Oups!  Error...
> 
> Correction: So as soon as there is data you ***can't*** delete the
> table...
> 
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org
> [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Robert Fortin
> Sent: Wednesday, February 20, 2008 11:42 AM
> To: FDO Internals Mail List
> Subject: RE: [fdo-internals] PostGIS ticket 106 question
> 
> At first I thought that it was up to the provider to decide in what
> circumstance a class (table) could be deleted.
> Well, not really...
> 
> The documentation is not always clear and detailed but in this case the
> FDO spec for ApplySchema is pretty clear (extract from
> http://fdo.osgeo.org/files/fdo/docs/FDO_API/index.htm FdoIApplySchema
> Class Reference)
> 
> If schema changes include deletion of classes or the schema itself, then
> those classes (or the schema, if it is marked as deleted) must not contain
> any instance data. If they do, an exception will be thrown.
> 
> So as soon as there is data you can delete the table.  You must empty the
> table before you can delete it.
> 
> RF
> 
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org
> [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Mateusz Loskot
> Sent: Wednesday, February 20, 2008 11:22 AM
> To: FDO Internals Mail List
> Subject: Re: [fdo-internals] PostGIS ticket 106 question
> 
> Bruno Scott wrote:
>> As we are about to fix that one
>>     http://trac.osgeo.org/fdo/ticket/106
>> Just want to check with you guys because there is a debate on that one
>>
>> http://www.nabble.com/Defects-in-PostGIS-provider-to12280094s18162.html#a12295194
>>
>> For my point of view, as PostGIS allow dropping table with the SQL "Drop
>> table" it's safe to do so.
> 
> Bruno,
> 
> It should be safe at least in current version of PostGIS provider,
> I mean where a feature class mapping to physical table is simple
> one-to-one relation, but if in future there is more complex mapping
> available then simple DROP TABLE may break data consistency.
> 
> 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
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
> 
> 

-- 
View this message in context: http://www.nabble.com/PostGIS-ticket-106-question-tp15591249s18162p15593982.html
Sent from the fdo-internals mailing list archive at Nabble.com.