中国最专业的商业控件服务网

慧都控件网

电话：400-700-1020(免费)或023-66090381
product
十年的Flash图表经验，十年Fusionchart辉煌
  • 您可能会用到这些产品
  • 授权相关问题
  • 相关文章
  • 暂时没有相关新闻
上一个 上一个 Data Generator for MySQL 下一个 下一个Data Generator for PostgreSQL
SQL Manager for PostgreSQL
[产品编号： 10857 ]  
SQL Manager for PostgreSQL

收藏订阅
  • 当前版本：v5.1   [销售以商家最新版为准，如需其他版本，请来电咨询]
  • 开  发 商：EMSSoftware 正式授权
  • 产品类型：软件
  • 产品功能：数据库管理
关于本产品的分类与介绍仅供参考，具体以商家网站介绍为准。
产品介绍 下载 购买 版本更新 开发商 视频与培训 评论  
SQL Manager for PostgreSQL v4.6.0.1(最新版) (09-09-24) v4.5.0.2

SQL Manager for PostgreSQL 版本更新 v4.6.0.1 (更新日期：9/24/2009)
  1. Added support of new PostgreSQL 8.4 features:
    • Variadic functions; functions returning table; function argument default values.
    • ON TRUNCATE triggers.
    • SELECT queries containing WITH clause.
    • pg_dump/pg_restore options (the options are added to the Backup and Restore Database wizards).
    • Sequence’s start value.
  2. SQL Editor.
    • Using macro is now possible.
    • Highlighting of the corresponding brackets is added.
    • Fixed several bugs concerning the incorrect parsing of table aliases in queries.
    • The line with an error was not highlighted correctly even if the error message contained the correct information. Fixed now.
    • Query interruption is now performed via libpg.dll instead of the pg_cancel_backend function. It is not necessary to be a superuser to interrupt your own query.
    • If a file name and location were too long for the window title, the utility used to cut the filename. Now it cuts the file location.
    • When a query returned the Infinity value to a timestamp filed, the utility used to display this value as Null. Fixed now.
  3. Data View.
    • When viewing table data, BLOB data are now loaded from server only when accessing them.
    • The support of the Infinity, -Infinity and NaN values is added for ‘real’ and ‘double precision’ fields. 
    • The Perform data sorting on client and Perform data filtration on client options were removed. The utility now selects the optimal mode automatically.
    • A syntax error sometimes occurred on inserting huge data to a bytea field. Fixed now.
  4. Function Debugger.
    • The RETURN QUERY and RETURNING … INTO … statements are now supported.
    • An error occurred on fetching data from ‘for execute’ cursor. Fixed now.
    • A syntax error used to occur if a function contained FOR … IN EXECUTE … LOOP statement. Fixed now.
  5. Extract Database.
    • Non-user objects used to be loaded when extracting a whole database. Fixed now.
    • The Add OID into object comments option is added. 
    • The speed of the data extraction is increased.
    • The Constraints’ description was extracted as COMMENT ON INDEX that resulted in an error. Fixed now.
  6. Function Editor. 
    • Cursor data returning by a function can now be exported.
    • The ‘List index out of bounds’ error occurred when editing some functions’ body. Fixed now.
    • When compiling a function returning data of the composite type, the utility generated the wrong script. Fixed now.
  7. Functions’ DDL. 
    • Arguments are ordered in a column now.
    • The Parameter name was not quoted even if it was a key word. Fixed now.
    • The “char” (pg_catalog.char) parameter was displayed as CHAR. Fixed now.
  8. Changing Metadata. 
    • The Recompile with Double Timeout and Recompile with Unlimited Timeout buttons now appear if the script execution was stopped due to timeout limit exceeding.
    • Monospaced font is used for error messages containing a code fragment and an error position pointer.
  9. Grant Manager. When granting rights to a table with the SERIAL field, the utility now suggests granting rights to the corresponding sequence.
  10. SQL Script. If a file name and location were too long for the window title, the utility used to cut the filename. Now it cuts the file location.
  11. Export as SQL Script. When a table definition was formed during the export to PostgreSQL, field types used to be defined incorrectly. Fixed now.
  12. DB Explorer. The Restart Sequence command is added to the Task menu.
  13. Data Export. When exporting data of the decimal type with the precision more than 14 digits, the numbers were rounded to the 4th decimal digit. Fixed now.
  14. Table Editor. The Refresh command didn’t work at the Description tab. Fixed now.
  15. The wrong script was generated when NOT NULL fields were added to a table containing default values. Fixed now.
  16. View Editor. Sometimes the query text was formatted improperly. Fixed now.
  17. Print Metadata. The long function title used to hide the part of the function text in the report. Fixed now.
  18. Visual DB Designer. If a field that connects tables was dropped and diagram containing these tables was opened, the “List index out of bounds” error used to occur. Fixed now.
  19. SQL Monitor, Backup/Restore wizards. Non-English messages weren’t converted from UTF-8 to Unicode. Fixed now.
  20. Fixed some errors that occurred when working in the Floating windows mode. 
  21. Other small improvements and bugfixes.