View Issue Details

IDProjectCategoryView StatusLast Update
0001699SymmetricDSBugpublic2014-06-16 20:27
ReporteryitziAssigned Tochenson 
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version3.5.21 
Target Version3.6.0Fixed in Version3.6.0 
Summary0001699: Changing Trigger results in Error om Tables with an uppercase letter
DescriptionAny Table that has an uppercase letter in its name, that has one of its triggers changed. Results in the following error.

drop trigger SYM_ON_D_FOR_NTFYNT_SB4 on NotifyUnit and failed because: ERROR: relation "notifyunit" does not exist

It appears that SQL statement it is using is
drop trigger SYM_ON_D_FOR_NTFYNT_SB4 on NotifyUnit;
instead it should be
drop trigger SYM_ON_D_FOR_NTFYNT_SB4 on "NotifyUnit";
Steps To ReproduceCreate a table in postgres with a capital letter
Add a trigger in sym_triggers for that table
Add a router in sym_router and sym_trigger_router

Start up symmetricDS. It will successfully create the trigger

Now add a second router in sym_router and sym_trigger_router (to replicate to a 3rd database)

Restart SymmetricDS, the error should appear.

We tested on 3.5.10 and 3.5.21
Additional InformationAlthough we would like to rename all tables to lowercase, its a legacy system and we are unable to.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: master 32165c7f

2014-04-29 11:48:19

chenson

Details Diff
0001699: Changing Trigger results in Error om Tables with an uppercase letter
0001699
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/postgresql/PostgreSqlSymmetricDialect.java Diff File

Issue History

Date Modified Username Field Change
2014-04-29 04:06 yitzi New Issue
2014-04-29 09:07 chenson Assigned To => chenson
2014-04-29 09:07 chenson Status new => assigned
2014-04-29 09:07 chenson Target Version => 3.6.0
2014-04-29 11:48 chenson Status assigned => resolved
2014-04-29 11:48 chenson Fixed in Version => 3.6.0
2014-04-29 11:48 chenson Resolution open => fixed
2014-04-29 12:00 Changeset attached => SymmetricDS trunk r8211
2014-06-16 20:27 chenson Status resolved => closed
2015-07-30 21:49 chenson Changeset attached => SymmetricDS master 32165c7f