In this release we focused on changes in the 9.2 version of the PostgreSQL server

Support for new JSON, SMALLSERIAL and range types introduced.

Internal SQL parser improved a lot and is fully compatible with PostgreSQL SQL dialect.

Collation support for tables introduced as well.

LEAKPROOF stored routine specification is supported from now, as well as security_barrier option added for views.

And of course all known bugs are fixed.

Download

You're welcome to download the Database Designer for PostgreSQL 1.8.4 right now at: http://microolap.com/products/database/postgresql-designer/download/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Full changelog:

• [!] Color Palette customization ability added
• [!] User Type and Domain selection tab added to reverse Engineering dialog
• [+] COLLATION support for table columns added
• [+] COMMENT clauses now proccessed by SQL Reverse Engineering
• [+] JSON type support added
• [+] Support for built-in range types added (INT4RANGE, INT8RANGE, NUMRANGE etc.)
• [+] LEAKPROOF function specification added
• [+] security_barrier option added for views
• [+] SMALLSERIAL data type added
• [*] "Import from SQL Script" dialog allows to edit script if error occured
• [-] "SQL Reverse Engineering cannot import function with argument of anyelement type" bug fixed
• [-] "SQL Reverse Engineering cannot import function with name Op" bug fixed
• [-] Random "List index out of bounds" error fixed during Reverse Engineering of enum types
• [-] "Cannot clear CHECK clause for DOMAIN in the UDT Editor" bug fixed
• [-] "Drag-and-drop multiple selected items causes all to go in top left hand corner" bug fixed
• [-] "Reverse Engineering of tablespaces broken in PostgreSQL 9.2" bug fixed
• [-] "Temporary property of views is not saved" bug fixed

REDMOND, Wash. — Sept. 25, 2012 — The Knoxville Chamber of Commerce, recognized as the 2011 National Chamber of the Year by the American Chamber of Commerce Executives and the leading voice for business in Knoxville, Tenn., and beyond, has switched to Microsoft Dynamics CRM and Microsoft Dynamics GP to help innovate and develop new programs and benefits for its member businesses.

“Before Microsoft Dynamics CRM and Microsoft Dynamics GP, the Knoxville Chamber was working in a box,” said Mark Field, senior vice president of membership. “This box impeded us from helping our member businesses reach their potential, but now we feel ahead of the technological curve. More importantly, our customers can see that shift as well.”

With the help of Microsoft partner LMBC Technologies LLC, the chamber created one of its most beneficial resources, Chamber Member MD, which helps small business owners identify potential hazards that might be in the way of achieving their companies’ full potential. The tool then offers customized recommendations to ensure they avoid those hazards if at all possible.

Microsoft Dynamics also enabled the chamber to launch an online interactive business directory called iKnowKnoxville.com. The directory is search engine optimized and allows member businesses to create customized pages that include videos, slide shows, coupons and more, further highlighting their unique business proposition and supporting the local economy.

“The support process that used to take 15 hours each week has been reduced to one hour each week, and the chamber is able to be more relevant to businesses by providing these individualized resources,” Field said. “This benefits us because we are providing much-needed resources to our members, and it benefits our members by allowing them to focus on doing what they do best — running their businesses."

“Later this year, we intend to upgrade to the latest versions of Microsoft Dynamics CRM and Microsoft Dynamics GP,” Field said. “These improvements will ensure that the Microsoft Dynamics implementation will continue to grow with the chamber, but really, I’ve told my peers that Microsoft should be considered for chambers across the nation.”

More information about how organizations are turning to Microsoft technology is available in the Microsoft Customer Spotlight newsroom.

Founded in 1975, Microsoft (Nasdaq “MSFT”) is the worldwide leader in software, services and solutions that help people and businesses realize their full potential.

Note to editors: For more information, news and perspectives from Microsoft, please visit the Microsoft News Center at http://www.microsoft.com/news. Web links, telephone numbers and titles were correct at time of publication, but may have changed. For additional assistance, journalists and analysts may contact Microsoft’s Rapid Response Team or other appropriate contacts listed at http://www.microsoft.com/news/contactpr.mspx.