killorad.blogg.se

1. EMS SQL MANAGER LITE FOR POSTGRESQL SERIAL
2. EMS SQL MANAGER LITE FOR POSTGRESQL CODE
3. EMS SQL MANAGER LITE FOR POSTGRESQL DOWNLOAD

When creating a foreign key its sign was not refreshed at the Fields tab. Names of the tables in lowercase were not highlighted as link in SQL editor if written in capital letters. When returning to a previous step the parameters entered were not saved. At the ‘Selecting objects for report’ step the buttons for selecting/excluding all objects are added.ĭownload File wizard. In some rare cases the AV error raised when disconnecting from a database. On attempt to add a parameter the AV error occurred. The Favorite Query tab (when it was created) used to disappear after refreshing.

Works faster with the databases containing many objects. The Create Database and Drop Database items are added to context menu. When exporting data to a file the warning window is displayed if the file already exists.ĭB Explorer: 1.

EMS SQL MANAGER LITE FOR POSTGRESQL SERIAL

Now the field is considered to be of SERIAL type only when its sequence name corresponds to the table name and field name.Įxport Data as SQL Script. In table DDL the method of checking whether the field is of SERIAL type is improved. When several copies of SQL Editor are used and the content of one of them is being saved, the changes in the content of the other ones are also considered. In some rare cases one was unable to interrupt query execution also, with some specific options set, interrupting query execution raised an error and lead to disconnecting from the server. When saving the tab content into a file, after moving tabs, the file turned out to be linked to a wrong tab. For the table with the name in lowercase in SELECT queries whenever the table name contained capital letters the results of the query turned to be read-only.

EMS SQL MANAGER LITE FOR POSTGRESQL CODE

The Code Completion window didn’t open for the first word of the first line in editor. Object names in uppercase are inserted in quotes now. When inserting data into TEXT fields the data used to get truncated to 8 kb size. The ‘Word wrap in string fields’ option is added as well. For strings longer than 80 characters the editor for TEXT fields is opened. In many object lists the ability to perform incremental search appeared.īlob Editor could not be used for text fields. The spell checking parameters can be set at the Spell Checking tab of the Editor Options dialog. Spell checking feature is implemented in SQL editors to check and perform corrections to SQL code automatically. Now the codepage can be set for a file when opening/saving it in SQL editors. To activate this mode set Batch insert as import type at the ‘Set import and data write type’ step. Import using COPY command is implemented. What's new in SQL Manager 2007 for PostgreSQL v.4.1?ĭata Import wizard.

EMS SQL MANAGER LITE FOR POSTGRESQL DOWNLOAD

You can download the newest version from the download page at EMS Database Management Solutions are pleased to announce the new version of SQL Manager 2007 for PostgreSQL.