You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@empire-db.apache.org by "Rainer Döbele (Jira)" <ji...@apache.org> on 2020/05/04 11:01:00 UTC
[jira] [Resolved] (EMPIREDB-284) Sequences left after dropping my
PostGreSQL dataBase
[ https://issues.apache.org/jira/browse/EMPIREDB-284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rainer Döbele resolved EMPIREDB-284.
------------------------------------
Resolution: Duplicate
> Sequences left after dropping my PostGreSQL dataBase
> ----------------------------------------------------
>
> Key: EMPIREDB-284
> URL: https://issues.apache.org/jira/browse/EMPIREDB-284
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-2.4.7
> Reporter: Samir Hadzic
> Priority: Major
>
> This is the exact same issue of EMPIREDB-279.
> In Postgresql we create a sequence when creating a Database :
> {code:java}
> @Override
> protected void createDatabase(DBDatabase db, DBSQLScript script)
> {
> // Create all Sequences
> for (DBTable table : db.getTables())
> {
> for (DBColumn dbColumn : table.getColumns()) {
> DBTableColumn c = (DBTableColumn) dbColumn;
> if (c.getDataType() == DataType.AUTOINC) {
> createSequence(db, c, script);
> }
> }
> }
> // default processing
> super.createDatabase(db, script);
> }{code}
> But there is nothing overriden for DDLscript when dropping the table in order to also drop the sequence.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)