View Issue Details

IDProjectCategoryView StatusLast Update
0006217SymmetricDSBugpublic2024-02-15 20:28
Reportermistermij Assigned To 
Status closedResolutionfixed 
Product Version3.15.2 
Target Version3.15.4Fixed in Version3.15.4 
Summary0006217: Schema information missing from drop index query generated by DDL on PostgreSQL
DescriptionThe query the DDL generates for dropping an index, silently fails when the owning table is on a different schema.
Steps To ReproduceOn a PostgreSQL have two schemas: public & sym.
Have SymmetricDS engine use the `sym` schema.
Create a table with an index on `public` schema.
Send the schema to transfer the table ddl.
Edit the table, dropping the index.
Send the schema to transfer the table ddl.
If you've the debug logs enabled, you'll notice the execution of the drop index failed, because the index was not found.

Tagsddl/schema, dialect: postgresql


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 9a4f050b

2024-02-14 19:09:49


Committer: GitHub Details Diff
0006217: Add schema information on drop index DDL for PostgreSQL (0000192) Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/ Diff File

Issue History

Date Modified Username Field Change
2024-01-31 13:55 mistermij New Issue
2024-01-31 13:55 mistermij Tag Attached: ddl/schema
2024-01-31 13:55 mistermij Tag Attached: dialect: postgresql
2024-02-14 19:10 emiller Status new => resolved
2024-02-14 19:10 emiller Resolution open => fixed
2024-02-14 19:10 emiller Fixed in Version => 3.15.4
2024-02-15 20:28 mistermij Changeset attached => SymmetricDS 3.15 9a4f050b
2024-03-19 16:20 admin Status resolved => closed