[fdo-internals] PostGIS ticket 106 question

[Bruno Scott]

Just went deep inside our unit testing
we are actually deleting all data before deleting the table :)
So it's why it was working on all these provider.
Sorry for this guys.

So we're gona check for data before droping ...

Bruno



Brent Robinson-5 wrote:
> 
> Yes, these would be defects. The unit tests for the Sdf, Autodesk Oracle,
> MySQL, and Autodesk SqlServer providers exercise this case but maybe there
> is some situation where the delete of a class with data is still
> succeeding.
> 
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org
> [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Bruno Scott
> Sent: Wednesday, February 20, 2008 12:19 PM
> To: fdo-internals at lists.osgeo.org
> Subject: RE: [fdo-internals] PostGIS ticket 106 question
> 
> 
> 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.
> 
> _______________________________________________
> 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-tp15591249s18162p15613511.html
Sent from the fdo-internals mailing list archive at Nabble.com.