Start a new topic

Feature Request: add support for postgres' CONSTRAINT RENAME in Alter Table

[This topic is migrated from our old forums. The original author name has been removed]

Hello Roger & Friends, First of all, thanks for making my life as a developer SO much easier by pouring your efforts into DbVisualizer! I have a request for a feature in the Alter Table interface. I've been experiencing the need to rename foreign keys lately, and I really wish the Alter Table interface would allow us access to Postgres' (9.1+) CONSTRAINT RENAME feature, as in this example: ALTER TABLE table_name RENAME CONSTRAINT current_key_name_fky TO new_key_name_fky; Anyway, I hope you folks are doing well! Thanks for any consideration you might give to this feature. Best regards, Jason Ziegler Memphis, Tennessee USA

Hi Jason


I just wanted to let you know that we have released DbVisualizer 9.5 yesterday with support for the feature you asked for. Please upgrade to the latest official version. Easiest is that you open Help->Check for Update in DbVisualizer to perform the upgrade.


An alternative is that you download from our web site: 


http://www.dbvis.com/download/


Best Regards,

Hans

[This reply is migrated from our old forums.]

Re: Feature Request: add support for postgres' CONSTRAINT RENAME in Alter Table
Jason, We just launched the BETA testing of the upcoming 9.5 version with a few improvements for PostgreSQL including support for rename. It would be great if you can give it a test and verify. http://www.dbvis.com/download/beta/ For more information about the news in the BETA version: http://www.dbvis.com/doc/relnotes/index.jsp?showheader=false&showtoc=false&version=9.5-BETA We plan to go public with 9.5 in a few weeks. Regards Roger
[This reply is migrated from our old forums.]

Re: Feature Request: add support for postgres' CONSTRAINT RENAME in Alter Table
Hi Jason, Good timing. We are updating the PostgreSQL profile for the next feature release so we will have a look at this as well. Best Regards, Hans