Devart Forums

Does not work the delete database for PostgreSql.
When running DeleteDatabase() command, like this:
generated incorrect code:
that's the correct code: For information:

The correct behaviuor is described in the documentation:
"Creates and executes script that deletes database tables with their constraints, indexes, and foreign keys.
If deleteSchema is set to true, the schema will be deleted.
The database or schema itself is not deleted."

Do not understand.
1) For MS SQL Server and MySQL when deleting base executed correct command.
2) For PostgreSQL executed an incorrect command.
Is necessary for PostgreSQL do the right commands.
I showed an example of the correct command. You want to say that this will not work?

If deleteSchema is set to true, the behaviour is the following:
DROP DATABASE is generated for SQL Server
DROP DATABASE is generated for MySQL
DROP SCHEMA is generated for PostgreSQL
DROP USER is generated Oracle
the database file is removed from file system in case of SQLite

The DeleteDatabase(false,true) was designed to remove the smallest "container" of database objects. For PostgreSQL, it is a schema. The behaviour change may lead to the unexpected result (removing database) for other customers, so we preserve current way how it works.

Well, for "PostgreSql" type I tried that. But so, too, the database is not removed. Only remove the table. Generated commands like: How to remove the database itself?

There are two ways to remove database:

1) via ADO.NET connection (PgSqlConnection), connect to other database (e.g., "postgres") and execute cmd.CommandText="drop database cetest"

2) implement your own descendant of a standard PgSqlDataProvider class, override its DeleteDatabase method, and employ your own class instead of a standard PgSqlDataProvider class