Drop Cascade not happening

[ccampbell]

(VB.Net 2010 / Devart Version 6.5.192.0 / PostgreSQL 9.2.3)

Hi using the following code I created a backup:

Code: Select all

pgDump.Connection = conn
pgDump.Schema = gclsSession.pg_Schema
pgDump.IncludeDrop = True
pgDump.ObjectTypes = PgSqlDumpObjects.Tables + PgSqlDumpObjects.Indexes + PgSqlDumpObjects.Sequences + PgSqlDumpObjects.Constraints + PgSqlDumpObjects.Views
pgDump.Backup(strFullPath)

The restore is failing:

Code: Select all

pgDump.Connection = conn
pgDump.Restore(strFullPath)

stating that it can't drop a view because it's being used by other objects, which is correct but I would expect the drop code to drop cascade the views.

Any ideas on how to deal with this situation?

Thanks,

Chris

[Pinturiccio]

We will investigate the possibility to solve the problem with dependent objects deletion in PgSqlDump and notify you about the results as soon as possible.

[ccampbell]

Hey guys, don't lose too much sleep over this one. I found that working within a specific schema avoids the issue. The user was attempting to backup from one schema and restore into another. Something that apparently is not supported.

Thanks,

Chris

[Pinturiccio]

The issue is reproduced when backing up and restoring within one schema. We have fixed the bug with dropping an object when other objects depend on it during PgSqlDump.Restore(). We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

[Pinturiccio]

The new build of dotConnect for PostgreSQL 6.5.202 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=26197