{"id":6023,"date":"2018-01-19T19:35:16","date_gmt":"2018-01-19T19:35:16","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/sql-manager-for-postgresql-v-3-8-released\/"},"modified":"2018-01-19T19:36:10","modified_gmt":"2018-01-19T19:36:10","slug":"sql-manager-for-postgresql-v-3-8-released","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/sql-manager-for-postgresql-v-3-8-released\/","title":{"rendered":"SQL Manager for PostgreSQL v. 3.8 released"},"content":{"rendered":"
\n
\n
By EMS Software Development<\/div>\n
on January 25, 2007<\/div>\n<\/p><\/div>\n
\n

EMS Database Management Solutions is pleased to announce a new version of PostgreSQL Manager.<\/p>\n

What’s new in PostgreSQL Manager 3.8?<\/p>\n

– SQL Script..
\nAbility to execute selected statements and statement under cursor added.
\nAbility to execute the statements like COPY FROM STDIN.
\nThe notices returned by server when executing statements are now displayed at the message list.
\nThe scheme set via the SET search_path operator is now taken in consideration when forming the object name to be displayed at the Explorer.
\nError list was not cleared when loading a file.
\n-Grant Manager. The ability to set the grants with grant option added.
\n-Extract Database
\nNow its possible to extract data as a set of COPY statements.
\nComparing with the previous version of the tool, extract process now takes less time.
\nThe Dollar-quoted function body option is now applied to the function definitions created by Extract Database wizard.
\n-SSH Tunneling. <\/p>\n

Support of authentication by key.
\nThe ability to establish connection for several hosts\/databases at the same time is added.
\n-Function Debugger. <\/p>\n

Dollar-quoted strings support implemented.
\nSELECT INTO statements are now supported.
\nVariables list: affected rows and result oid added.
\nFixed the bug with incorrect work of a function containing variables like table_name.column_name%TYPE
\nWhen executing the Continue operator the syntax error used to occur. Fixed now.
\nThe RAISE NOTICE command terminated function execution. Fixed now.
\n-Data Grid. <\/p>\n

Filter applied for date type fields worked incorrectly if a date format type other then MDY was used in system settings. Fixed now.
\nOn attempt to apply any filter with the SQL filter and Select only * records limitation used the data were displayed incorrectly. Fixed now.
\nMouse-wheel scrolling for the Form View is implemented.
\n– Dependency Tree.<\/p>\n

With the Show subobjects option enabled the dependencies were displayed not quite correctly. Fixed now.
\nObjects icons were not printed.
\n-Server Configuration, Parameter List tab. The Parameter Group column added which allows to display the parameters in groups.
\n-Visual Options. The ‘Menus show recently used commands first’ option added.
\nEditor Options. The ability to set default colors added.
\n-Environment Options, DB Explorer tab. The ‘Refresh object on showing in SQL Assistant’ option is added.
\n-DB Explorer. A newly-created object was not listed in the Recent Objects drop-down menu.
\n-Data Import. When importing from DBF format the default values for the boolean type were False and True (instead of required F and T), so it was necessary to change them for proper ones while processing the data. Fixed now.
\n-Environment Options, Windows tab. The Number of open editors is restricted option didnt work. Fixed now.
\n-Environment Options, Preferences. The Save desktop on disconnect option didnt apply to rules, indices, triggers and reports.
\n-Log Viewer. On attempt to open a local PostgreSQL server log the IO error 32 error raised and the current log did not open. Fixed now.
\n-Other small improvements and bugfixes.
We hope you’ll enjoy working with our products!<\/p>\n

\nFor more info, visit:
http:\/\/www.sqlmanager.net\/products\/postgresql\/manager<\/a><\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

EMS Database Management Solutions is pleased to announce a new version of PostgreSQL Manager. What’s new in PostgreSQL Manager<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-6023","post","type-post","status-publish","format-standard","hentry","category-news"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6023","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=6023"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6023\/revisions"}],"predecessor-version":[{"id":6848,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6023\/revisions\/6848"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=6023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=6023"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=6023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}