Mixed case Index names are not quoted

PostgreSQL - related issues
Post Reply
greg
Posts: 3
Joined: Mon Feb 04, 2013 12:43 pm

Mixed case Index names are not quoted

Post by greg » Mon Feb 04, 2013 1:36 pm

Hi,
I'm using DbSchema build 3716 and found that when schemas are compared to database and an index name is changed, in the resulting SQl for renaming index in the database both old and new name of the index are not quoted and PostreSQl complains that such index does not exist.
It is possible to workaround this by amending the SQL template in Database settings tab Statements, but this settings are not saved! If you close and reopen DbSchema the changes are lost.
Regars

donose.mihai
Posts: 470
Joined: Thu Apr 07, 2011 11:05 am

Re: Mixed case Index names are not quoted

Post by donose.mihai » Mon Feb 11, 2013 9:10 am

Yes you can, from the database settings dialog after amending the changes, press ENTER and then save, restart DbSchema, the changes should be there, i'll have a look also later on today.

mithcd143
Posts: 27
Joined: Fri Jun 14, 2013 3:52 pm

Re: Mixed case Index names are not quoted

Post by mithcd143 » Fri Jun 14, 2013 3:57 pm

Just a follow up. this works on previous versions as well, correct?

mickel12
Posts: 1
Joined: Fri Mar 13, 2015 10:40 am

Re: Mixed case Index names are not quoted

Post by mickel12 » Fri Mar 13, 2015 10:42 am

Nice Post :lol: :lol:

Post Reply