[fdo-internals] PostGIS ticket 106 question

[Robert Fortin]

Bruno,

I tried SDF and Oracle and they both fail to delete a class when there is data.
Given that result, I didn't try all the other providers and assume that there is something particuliar in how you reach this conclusion.
What steps/sequence did you go through to get to this conclusion?

RF

-----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