Change History Version 1.3.4 Build 50 March 9th 2008 ========================================= - 0000110: [Bug] incorrect DDL when quotes are present in comments (acaduto) - 0000105: [Bug] Text-based primary keys in tables (acaduto) - 0000106: [Bug] "column number 0 is out of range 0..-1" error message (acaduto) Build 49 January 17th 2008 ========================================= - 0000102: [Bug] Can't create a user thru PGLA (acaduto) - 0000104: [Feature Request] Warn user when "Backup Database" and "Restore Database" will misbehave (acaduto) - 0000103: [Bug] Column width bug in data grids (acaduto) Build 48 January 8th 2008 ========================================= - 0000101: [Bug] SELECT queries made in query editor view not displaying results (acaduto) Build 47 January 6th 2008 ========================================= - 0000095: [Bug] [Edit Trigger] form [DDL] tab - Incorrect DDL for Constraint Triggers (acaduto) - 0000097: [Bug] Unexpected "column number 0 is out of range 0..-1" error message (acaduto) - 0000094: [Feature Request] Comment Text boxes (acaduto) - 0000050: [Bug] UTF-8 files saved from Query Editor cannot be read by psql (acaduto) Build 46 December 17th 2007 ========================================= [Change] Turned off apply best fit routine to grids. Should provide nice speed boost Build 45 December 4th 2007 ======================================== - 0000092: [Bug] App data directory not detected properly on some OSes and WINE (acaduto) - 0000093: [Bug] gdiplus.dll required on versions of windows less than XP (acaduto) Build 44 November 13th 2007 ========================================= - 0000088: [Bug] Update to View with update rule causes syntax error message (acaduto) (This was actually caused by a sql parser bug in the PostgresDAC client access lib) Build 43 November 10th 2007 ======================================== - 0000087: [Bug] Editing a function using the Edit in query editor option would use the query editors cached copy instead of the server copy. (acaduto) - 0000086: [Bug] Program would sometimes hang on shutdown if a open SSH connection was still connected. (acaduto) Build 42 September 18th 2007 ========================================= - 0000080: [Bug] Export data from result grid leaves open directory handle (acaduto) - 0000082: [Bug] create function fails [List index out of bounds (1)] (acaduto) - 0000083: [Bug] Comment of function doesn't work (acaduto) - 0000056: [Bug] Import data tool becomes slower with more inserts (acaduto) + 0000000: [New Feature] Report Designer added to query editor Build 41 August 15th 2007 ========================================= - 0000078: [Bug] Can't change existing field default value to function call (acaduto) - 0000079: [Bug] "Cannot focus a disabled or invisible window" when working with multiple tabs (acaduto) Build 40 July 20th 2007 ========================================= - 0000074: [Bug] Dropping a user that has dependent objects does not raise a error (acaduto) - 0000075: [Bug] Query editor has issue executing a update with a select subquery (acaduto) Build 39 June 30th 2007 ========================================= - 0000073: [Feature Request] Add "table-like" toolbar to view form editor (acaduto) Build 38 June 19th 2007 ========================================= - 0000061: [Feature Request] exec_log.html log files are logging passwords (acaduto) Build 37 June 5th 2007 ========================================= - 0000067: [Bug] Rule Editor doesn't allow multiple SQL statements (unless to trick it) (acaduto) - 0000066: [Bug] Rule Editor requires user to clean up bad syntax before rule can be commited. (acaduto) - 0000070: [Bug] version 36. Editing a rule's name leave two rules -> old + new (acaduto) - 0000071: [Feature Request] version 36. Can't set default 'infinity'::timestamp with time zone for new column. (acaduto) - 0000069: [Bug] version 36. During view create, selecting tabs {rules},{data},{ddl} triggers error messages (acaduto) - 0000068: [Feature Request] release 36 - pressing Deleted on View's -> rule list appears to remove two rules (acaduto) Build 36 June 1st 2007 ========================================= - [Bug] Fixed a issue with the updated Quantum Grid used in the latest build that caused the following error on W2k systems "Class tdxpngimage not found" You can find out more here: https://www.devexpress.com/Support/Center/ViewIssue.aspx?issueid=AB13183 Build 35 May 31st 2007 ========================================= - 0000063: [Bug] Rule definition incorrectly displayed when opening rule edit form and selecting definition tab. (acaduto) - 0000062: [Bug] A temporal view using "Current sequence" model crashes pgLA (acaduto) Build 34 May 20th 2007 ========================================= - 0000060: [Bug] Form view for data gives error when using columns with spaces - 0000059: [Bug] now() converts to current time for datatype timestamp instead of function - 0000058: [Feature Request] Sort the trigger function drop-down selection list - 0000057: [Bug] Rename function trigger error message ***** Build 33 April 5th 2007 ****** + Added logic to detect if a the quick view data option is operating on a table or a view. If it's a view it does not add the order by 1. - Downgraded the compiler/IDE to Delphi 2006, some users where seeing odd issues when working with certain views. Switching back to Delphi 2006 seems to resolve the issues. Will try Delphi 2007 again when the first Service Pack/Hot fixes are released. ***** Build 32 March 22nd 2007 ****** +Now built with Delphi 2007 +Enabled double buffering on the backup/restore log windows, does not flicker any more. +Updated to PostgresDAC 2.3.8 which fixes a issue where the Quantum Grid could not update text/no length varchar fields. +SSL options have changed on the server connection properties. You can now set the SSLMode to disable,prefer,allow,required. Please see the PostgreSQL docs for more info on SSLMode. +Fixed a issue where the right click menu for the table editor and quick data viewer data grids where not showing. This prevented a user from viewing blobs in the blob viewer. ***** Build 31 March 10th 2007 ****** +Fixed the initial database combobox, which was set to a fixed drop down list. Changed it back to the standard drop down list. The fixed list only allows the user to pick from the hard coded list. This caused problems for users who had databases on a ISP server which did not allow them to have access the 3 default choices. ***** Build 30 March 4th 2007 ****** +Fixed a issue where the grant manager was showing the RULE permission as valid for tables etc on a 8.2 server. PGSQL ver 8.2 allows RULE to be granted, but does not do anything. This was changed because 8.2 only allows rules to be edited/created by the owner. +Fixed a issuw where the GRANT Connect permission was not working right in the Grant Manager. -Removed the user pane from the Grant Manager and replaced the list view it contained with a combobox. The functionalilty is the same, but results in a cleaner look for the Grant Manager. ***** Build 29 February 27th 2007 ****** +Fixed a issue where a backup and restore where not working from a unconnected database when the password was not stored. +Added a missing try except block to the postgresDAC psqldump where a exception was being raised and caused the cleanup of a temp file to fail. +Changed the font in the dump/restore dialog message tab to be fixed width. +Added both scrollbars to the message tab on the dump/restore dialog +Dump/Restore dialogs are now sizable so you can better see the messages. +Turned off word wrap on the Dump/Restore dialogs message tab. ***** Build 28 February 22nd 2007 ****** +Fixed a issue where a backup and restore where not working from a unconnected database because the password was not being decrypted and it was not checking if the connection needed ssl or not. +Fixed a issue where the service combo on the connection properties form was not saving it's value properly. It was also not setting the combobox item index properly as it was set to dropdownlist instead of a editable dropdown. +Added a copy option to the version history editor that is used to view the stored history. +Added Auto Complete to the editors. This is as you type auto complete and it is disabled by default. If you like this type of auto complete you can turn it on in the environment options on the editor tab. You will also need to adjust the auto complete timer interval to your taste, by default it is set to 500 and this will be way to fast for most typists. ***** Build 27 February 16th 2007 ****** +Added a routine that can detect if your old passwords are not encrypted, then encrypt them for you automaticly. This was done to assist users with LOTS of connections with stored passwords. ***** Build 26 February 11th 2007 ****** +Made some changes for Vista support. In Vista applications cannot write to the program install directory, so we moved all the writable files to the user profile under application data. The installer will automatically move the files when you update. +Further improved the FillFactor support by adding it to the index grid. +Indexes created by a PK or unique contraint are now shown in the index grid. This will allow you to adjust the fill factor for these auto created indexes. +Stored passwords are now encrypted for better security. ***WARNING*** YOU WILL NEED TO RESET ALL YOUR STORED PASSWORDS!! Auditors at financial institutions should not have a problem with the stored passwords now. Beware pgAdmin III stores your passwords in plain text!! +Added a Windows manifest so controls/widgets will theme when running on XP and up. We will be adding full Vista support as soon as we actually get a copy of Vista. +Fixed a few minor bugs that where found while adding the manifest. +Streamlined the new connection dialog by adding a tab that shows up when the SSH tunnel option is selected. +When selecting the SSH tunnel option a random port is set above 1024 and the host is changed to localhost. If the host was populated before the SSH tunnel option is selected, it is cached and will revert back if you change your mind about using the tunnel. +Set the PGPASSFILE environment var to a non existant file. This is done to prevent pgAdmin III from hijacking your connections with it's use of the pgpass.conf file. pgAdmin III uses the pgpass.conf to store it's passwords in a un-encrypted state. By using the pgpass.conf file it affects all applications that use libpq.dll. +Went through every form to ensure the tab order was correct. ***** Build 25 January 31st 2007 ****** +Turned on SSL support. There is now a SSL check box in the server connection properties. To use SSL you must have your server compiled with SSL support and OpenSSL installed. You must then turn SSL on in the postgresql.conf and create a self signed certificate and key, or purchase a cert from verisign. The server won't startup if the permissions of the key and cert are not set properly. Please see http://www.postgresql.org/docs/8.2/interactive/ssl-tcp.html for more info +Added FillFactor support (server 8.2 only) for new tables,constraints and indexes. (We have not added the ability to edit the fillfactor for a table yet, but will soon) +Added the ability to edit a index within the contraints of the ALTER INDEX statement (8.0 and up) On 8.0 to 8.1 you can edit the name and move the tablespace, on 8.2 you can edit the indexes FillFactor and it will ask you if you want to reindex. We ask because on a huge table the reindex may take awhile. ***** Build 24 January 26th 2007 ****** +Fixed a issue where bigint fields would not filter in the data grid. +Added GRANT CONNECT for databases when using the Grant Manager +Fixed a issue where a freshly added database would not be inserted into the tree sorted. +Improved the query editors error dialog box, it now shows the SQL State code, the primary error message, any additional detail if availalbe,the position of the error in the query, and any hint if available. +Updated the Postgresql Access library we use to 2.3.7 which was released on January 23rd. +Updated libpq.dll and all dependencies. Starting with this update we will no longer be putting the dlls in the windows system32 directory, so if you want you can remove them. The files to remove from the system32 directory are: - comerr32.dll - krb5_32.dll - libeay32.dll - libiconv-2.dll - libintl-2.dll - libpq.dll - ssleay32.dll All of these dlls will now reside in the Lightning Admin application directory. In addition this update now uses a pg_dump/pg_restore that are implemented as DLLs instead of executables and also reside in the application directory. ***** Build 23 January 23nd 2007 ****** +Updated the version check system to include a new auto update feature. For releases after this one, you will have the option to do a one click automatic update or a manual one. The one click auto update will not require a password and will only update the files that have changed. 99% of the time this is just the main exe. The auto update will stop LA, update the files, then automaticly restart LA. The manual upload will download the full setup.exe and you must know the password to run it. Both options now display a nice progress bar. ***** Build 22 January 21st 2007 ****** +Fixed a issue with the table DDL view. Tables with more than 1 FK where not displaying the table create statement on the ddl tab properly. +Column stats target info is now displayed in the table editor's grid and is editable via the grid itself as well as the column/field editor dialog. +Trigger name and comment was not editable via the trigger editor dialog. +Added functional DDL tab to trigger editor dialog. +Updated the column/field editor dialog and improved the way data types returned from the server. +Updated several other dialogs to use TNT UNICODE enabled controls. (this does not mean the app is fully UNICODE yet, the goal is to repalce all the controls(widgets) with the TNT unicode versions.) ***** Build 21 January 18th 2007 ****** +Fixed a issue where the setting of NOT NULL in the grid right after a new field/column was created failed. Not many know this, but you can edit the default value, comment and NOT NULL of field right in the grid. ***** Build 20 January 16th 2007 ****** +Fixed a issue where some before and after condtions where not showing properly for a existing trigger. Also the non editable areas of the existing trigger where not be disabled. +Fixed a issue where dropped columns where showing up in the query builder as ****pg.dropped.8**** etc. The Query that brought back the column names from pg_attribute was missing where attisdropped = false. ***** Build 19 January 12th 2007 ****** +Fixed some minor sorting issues when working with server groups. ***** Build 18 January 11th 2007 ****** +Added ORDER BY to the queries used to populate the lists on the user/role dialog. ***** Build 17 January 10th 2007 ****** +Fixed a parsing issue with the server setting for the pg_hba.conf +Fixed a issue where the clone connection option would not work if the connection was in a group. +Added the ability to set a comment for each entry in the pg_hba.conf. comments in the file would show up in the option column. +Improved the dependency viewer so you can now right click on a column/field name and view it's dependencies. +Made the dependency viewer sizable and adjusted the columns. +Improved the server settings query capture option. It now ignores the string that is shown when a process is not doing anything. It also will not capture a query that is already in the memo capture area. ***** Build 16 January 9th 2007 ****** +Fixed a version control regression that caused the FK editor not to execute the alter table sql. +Improved the dependency view, was not showing column names +Added a dependency viewer right click to the contraint,index,rule and trigger views in the table editor. +Added a copy OID to clipboard right click in the constraint,index,rule and trigger views in the table editor. ***** Build 15 January 8th 2007 ****** +Added new drop behavior for constraints, indexes etc, now during the confirmation dialog, you have the option of doing a cascaded drop. You may also view the dependencies if you wish. +Added a OID column to the index, constraint etc views in the table editor. ***** Build 14 January 4th 2007 ****** +The pg_get_viewdef was not set to use the pretty print flag. +Added a DDL tab to the view editor +The trigger editor was not showing existing triggers arguments. ***** Build 13 Dec 30th 2006 ****** +The table editor toolbar button drop index was not working. related to the bug fixed on Dec 26th. ***** Build 12 Dec 26th 2006 ****** +Fixed a bug that was introduced because of a tab caption change that caused the new index main menu item not to work. ***** Build 11 Dec 22nd 2006 ****** +Allowed the "Show System Objects" to display the template databases. +Fixed a bug in the server settings form that caused a list index out of bounds if the pg_hba.conf file has a entry for local Type with Method ident with out a Method option. The bug did not show itself if the local type entry had a Method option. ***** Build 10 Dec 18th 2006 ****** +Fixed a small bug that caused the form view of the data tab to not redraw when a new query was run and the tab was left on the form view. ***** Build 9 Dec 14th 2006 ****** +Added a incremental search capability to the database tree view. To use, just put the focus on the tree by selecting any node and just start typing the first few letters of what you are looking for. What you type will be echoed in the status bar as "Searching for: actor" if you stop typing the search will reset in 1 second. To continue the search after you have found a match wait for 1 second and start typing again. Works very well. ***** Build 8 Dec 13th 2006 ****** +Before we moved to a tabbed MDI interface if you dropped a table it would close the open table editor associated with it, this became broken with the tabs and it is now working again. It will also close a Quickview tab if open for the table in question. +Enhanced the trunctate table right click option, so when you truncate a table it refreshes the data grids automaticly in the open table editor or Quickview tab. +Enhanced the rename dialog, so when you rename a table it updates the currently open tables tab caption and other variables associated with the new name. ***** Build 7 Dec 11th 2006 ****** +Updated the import library from version 2.45 to 2.56. This resolved a issue when importing memo fields from a DBF file. +changed the new function dialog and function editor to quote param names. +Added the ability to export only selected records from the datagrids. +Fixed a bug that caused the function param hints to be corrupted in the db tree, this also caused a function drop to fail. ***** Build 6 Dec 6th 2006 ****** +Fixed a issue with the import wizard that was causing issues when importing from non MS Access datasources. +Added support for the 8.2 feature of adding/removing inherited tables to existing ones. This only works with 8.2 and up servers. There is now a inheritance tab on the table editor, you can remove a inherited table by right clicking on it's name and select remove. You can add a new inherited table by dragging and dropping a table from the db tree. +Added additional property values to the properties tab when tables are selected. Now shows info for inheritance. ***** Build 5 Dec 5th 2006 ****** +Fixed a issue where the version number was not being parsed out properly on a 8.2rc1 sevrver. Added Regular Expression support to pull out only the numbers and periods in the string and discard the rc1 or beta2 text. This caused the function params to not work right on the RC and Betas of 8.2. +Added the Concurrent Build option to the new index dialog (8.2 only) +Improved the look of the Index dialog. The same dialog is used for a new Primary Key constraint and a new unique index. +Improved the way the object preview works in the database tree. It now shows previews for a tables constraints,indexes,triggers and rules along with a at a glance count of the objects. +Added the constraint (where) option to the index dialog. +Modified the PostgresDAC access library so Lightning Admin can now connect to EnterpriseDB databases. NOTE: We do not support the enhanced Oracle features yet, but we plan to in the future. You can of course use these features via the query editor. +Other minor fixes and tweaks. ***** Build 4 Nov 29th 2006 ****** +Fixed a issue with the FK editor where referrenced names with caps where getting qouted twice i.e. ""blabla"" +Added a DDL tab to the FK editor. +Added a schema seach capability to the database object tree. You can use it by right clicking on the Schemas node or from the main menu Tools entry. Sorry but I was not able to implement shortcuts for the search feature yet because they conflicted with the search options for the query and function editor. The next build will also feature a search as you type option. +Fixed a issue where OIDs > than 2 billion where causing problems with standard integer types. Changed to a 64bit largeint type to fix this issue. Many older systems that have tables defined WITH OIDS can have OIDs greater than 2 billion. +The DDL tab on the domain editor is now working. ***** Build 2 Nov 27th 2006 ****** +Fixed a issue with the sequence single click property view. There was a syntax error that was double checking for caps and reserved words and caused a condtion with to many qoutes. +Added some missing options to the FK editor deferred, deferrable etc +Updated the .chm help file to include info on the new server groups feature. +Fixed a issue where the query capture in the server status window was capturing the IP address instead of the query ***** Build 1 Nov 18th 2006 ****** +Major new feature added. Lightning Admin for Postgresql now has the ability to create server groups in the Enterprise Manager to better organize large amount of connections. Please see this screenshot: http://www.amsoftwaredesign.com/downloads/server_groups.PNG To add a new group you can right click the servers node and select "Add New Server Group" You can then drag or drop you existing connections onto the new servers group node. You can also rename a group by right clicking on it and selecting "Rename server group" A server can also be added to a group from the server properties dialog. This feature will not be available for the MySQL version right away as it has to be ported over. Version 1.2.3 ***** Build 1071 Nov 8th 2006 ****** +The LIKE operator was not showing in the filter builder ***** Build 1070 Nov 7th 2006 ****** +Fixed a issue with the Quick View Data browswer that prevented edits in the grid. This only affected the Quick View. +Fixed a issue with the sequence editor form that prevented renaming of a existing sequence +Ported a fix from the MySQL version that turned on the ability to tab between cells in the main data grids (non unicode). +prior to this release you could not edit the time portion of a timestamp/datetime field in the Quantum Grid ***** Build 1069 Oct 24th 2006 ****** +Fixed a issue where a AV could occur if the DB was closed while a long running query was running. ***** Build 1068 Oct 11th 2006 ****** * Fixed a small issue with the FK editor and the references combo box (qouting issue). * Fixed a small issue with the User/Role editor, the Can Logon checkbox was not working. ***** Build 1067 September 6th 2006 ****** * Upgraded FastReports to version 3.23 was on 3.19 * Changed the FK editors referenced table combo box to show the tables sorted by schema then tablename. * Changed the font on all reports to be Arial instead of Tahoma, the Tahoma font caused the PDF export to look really bad unless embedded fonts where selected as an option. * Fixed a small issue where a blank entry could be added to the new table dialog's inherited tables list ***** Build 1066 September 6th 2006 ****** *Password for the registered setup has changed, please logon to the registered users forum to get it. *Fixed a bug where the CTRL+ENTER shortcut for executing a query would hang if the query started on the very first line of the editor. *Fixed a small issue with the SSH tunnel that would cause a AV when the SSH connection died on the server side. This caused a AV when you tried to disconnect from the dead connection. ***** Build 1064 August 3rd 2006 ****** * Added the ability to start/stop the local postgresql server. just open a local servers properties and select the * appropriate service name from the combo box. You can then right click on the server entry to start or stop the service. * Modifed the backup/restore dialog so the middle button says close, and changes to cancel when the operation is running, * and back to close when it finishes. Prior to this version it said cancel all the time. ***** Build 1062 July 29th 2006 ****** * There was a problem with the export routines as a result of moving to the client side sorting. * Prior to client side sorting the export routines where using the Quantum grid for export along with * the load all records mode, switching to the client side sorting no longer required the load all records mode * which caused a issue with the export routines which were set to use the grid rather than the underlying dataset. ***** Build 1061 July 19th 2006 ****** * Fixed a issue in the PostgresDAC client side sorting routine that did not like uppercase * fieldnames. Bug and solution was reported to the vender (www.microolap.com) ***** Build 1060 July 5th 2006 ****** * Added the ability to reorder the columns in the create index dialog, by user request. ***** Build 1059 June 22nd 2006 ****** * Client side sorting is back. Last year we used the Zeos components for our db access layer, and then * switched to PostgresDAC because it was geared 100% to Postgresql and supported things like notifications. * one of the things Zeos did have that PostgresDAC lacked was client side sorting of the result set. * we were able to get around this by using the grid mode of the Quantum Grid, but this effectively caused the entire * result set to be loaded into the grid after the tdataset received it, and on large result sets this * really slowed things down. Anyway all the grids in the program are now using the Delphi tdataset mode instead * of the load all record mode of the Quantum grid. Filter is now also enabled on the grids. * Before the grid loads we check the estimated row count and if it's greater than 300,000 we set the limit to * 1000 rows. We don't do a select count because on PG it's just way to slow on large result sets. ***** Build 1058 June 20th 2006 ****** * Modified the version setup.exe to show the app version info. * Changed the way the version check stored the last check date. It was being saved in the * registry as a string, now stored in binary form. * Found and fixed a bug in the PostgresDAC access library that involved updates in grids not working if you * deleted fields that caused the attnum value in pg_attribute to be out of sync with the physical order as * stored locally. The fix was passed on to Microolap so they can do a official fix. ***** Build 1057 June 19th 2006 ****** * Massive improvements to the online help file. We upgraded to Help and Manual version 4.x and it is simply * stunning. http://www.helpandmanual.com/ We didn't use H&M version 3 for the help because it could not import the * Postgresql docs in good enough quality, but the new version works great. We will also be * putting up a online http version of the help file as well as a printable PDF version. * NOTE: the help file has not been proof read yet, but we wanted to get it out as it is still a massive improvement * over the old help file. * Fixed a issue with the blob viewer where a stream read error would occur loading a binary file into a null bytea * column. * Fixed a issue with the function version control compare routine. The compare version routine will not work with * unicode text from the current version (the current text in the function editor) so we had to force a converion to a * non wide string for it to display properly. ***** Build 1056 June 10th 2006 ****** * Fixed a issue where a error would be raised if a sequence was named with a number i.e. 1001 ***** Build 1055 June 9th 2006 ****** * PGLA no longer maximizes the form at app start time, it now remembers last size,state and position and restores * it on your next logon. If you like it maximized, just leave it that way when you close and when you start it the next * time it will be maximized. ***** Build 1054 June 8th 2006 ****** * Was doing some more testing on linux with WINE and discovered WINE did not like the Delphi * inputbox function(because the inputbox function uses borderstyle:=bsdialog, for whatever reason WINE raises a AV * when the borderstyle is set at runtime. PGLA used the inputbox function in quite a few places, so I created my own * class called tinputbox and replaced all the calls to the VCL function. The result is PGLA works even * better with WINE, and the custom input box is much nicer looking. ***** Build 1053 June 7th 2006 ****** * Made some code change so PGLA works MUCH better with WINE and Linux. This is of course UNSUPPORTED. * The drop object confirmation dialog now gives you the option to view dependencies. * The drop object error dialog now displays the dependency notice from the server if a object can not * be dropped because another object references it. ***** Build 1052 June 6th 2006 ****** * Fixed a issue where the dependency viewer was not getting the correct oid for user defined composite types. * Added a dependency tab to the table and function editor forms. ***** Build 1051 June 2nd 2006 ****** * Fixed a issue where the comment of a column was not being saved in the column editor. * Fixed a issue where setting permissions for a group role in 8.1.x was failing. ***** Build 1050 June 1st 2006 ****** * We now have a dependency viewer, just right click on a objec in the DB tree and select "Dependency Viewer" * Fixed a bug where the grant manager would not open in a query editor was open in the same DB. ***** Build 1049 May 30th 2006 ****** *Fixed a AV that occured when a unprivelidged user tried to use the table quick data view ***** Build 1048 May 26th 2006 ****** * Completed the aggregate editor. ***** Build 1047 May 24th 2006 ****** * Added recent files picklist to the query editor, per user request. * Implemented query error fields support in PostgresDAC and contributed the code * Improved the query editors error reporting by using the error fields returned by the server, * if a query returns a error char position the line will be shown in the error dialog with the offending * position marked with a red ^, You can also click the go to error context button and the line in the editor will * be highlighted and the cursor moved to the offending position so you can make changes. * Added the start of the Aggregate editor, currently you can add new aggregates, but the editing part is not finished * you can only change a few properties of an existing aggregate anyway, so it's not a big deal. * NOTE: the new error capabilities only work in the query editor and generally won't work on queries inside of * a create or replace function DDL statement. ***** Build 1046 May 8th 2006 ****** * Added the ability for the user to define the open and save dialog filters, by default they will contain * SQL Files *.sql and All/Any Files *.* . The filters can be set from the General tab of the environment options * Dialog. ***** Build 1045 May 5th 2006 ****** * Continued improvement of the user/group functions when running 8.1. The user/group roles now use the same dialog box * when running against a 8.1 server. I think all 8.1 features are now supported. Note this is very new, so there may be * bugs. * Changed the Quantum Grid used in the query editor to not load all records, grid sorting/filtering is now disabled * in the query editor because of this. If you need it sorted add a order by to the query you are running. This * was done to enhance performace of large result sets. * The blob viewer now can be invoked on blob fields from the form view tab, prior to this update the blob edit button * on the form view did not work. ***** Build 1044 April 26th 2006 ****** * Added the variable tab to the user dialog. ***** Build 1043 April 24st 2006 ****** * The new field PK creation was messed up when the full table name(i.e.with schema) was * included in the create sql instead of the short table name. It is now fixed, we are sorry if this * caused anyone problems. ***** Build 1042 April 21st 2006 ****** * The new field dialog was naming the auto generated PK name with the field name instead of the * table name. * There was a AV present in the version check if you selected either type of authentication. ***** Build 1041 April 18th 2006 ****** * Table editors DDL tab was missing trigger create statements. ***** Build 1041 April 14th 2006 ****** * Automatic version check at startup and or every x number of days is working. * To use open the environment options dialog and adjust the version check options to * your needs. * All the version check code has also been moved to a thread so it will not slow down * the applications startup speed. ***** Build 1040 April 8th 2006 ****** * Added firewall and proxy authentication options to the version update check. * Next release will add auto update checking on startup where you will be able to check * at each startup or every x number of days. * Fixed a couple of bugs in the query editor. ***** Build 1039 March 29th 2006 ****** * Enhanced the MDI tabs for queries, now when a long running query is going the tabs icon will change and the caption * will be green bold text. The query timer will also be displayed in the tab. * The tab will return to normal after the query completes or the query is cancelled. ***** Build 1038 March 25th 2006 ****** * Fixed a issue with the mdi tab reordering via drag/drop * cleaned up the table editor field tab right click menu and added several new copy options. ***** Build 1037 March 24th 2006 ****** * implemented a ctrl+alt+G short cut in the query editor that will execute a query from the cursor position. * This works by seperating your queries with blank lines. This feature was added because of a user request. ***** Build 1036 March 23rd 2006 ****** * internal type float8 was being incorrectly mapped to double instead of double precision. ***** Build 1035 March 22nd 2006 ****** * Server setttings is now fully implemented. Please remember you need the admin pack(contrib module) from * http://www.pgadmin.org/download/adminpacks.php, the win32 postgresql installer will install this for you * as long as you don't uncheck it. ***** Build 1034 March 20th 2006 ****** * Server settings now works for the postgresql.conf file, but only if you have the admin contrib module installed. The next release will also allow the pg_hba.conf to be edited. In this release you can view the pg_hba.conf but not save it back to the server. After the config file has been saved back to the server you can reload the configuration. This has only been tested on version 8.1. ***** Build 1033 March 20th 2006 ****** * there was a small issue with timestamp and timestamptz ***** Build 1032 March 18th 2006 ****** * query builder was not showing views. ***** Build 1031 March 17th 2006 ****** * upgraded PostgresDAC to version 2.3.1 to resolve a long fieldname issue as reported by a user. * This version of PostgresDAC also has the official fix for the Timestamptz issue as reported by Ken ***** Build 1029 March 13th 2006 ****** * Added a data tab to the view editor. ***** Build 1028 March 6th 2006 ****** * Right click schema editor was missing,now added. * Dbexplorer list view works for all objects now, including views. * Table DDL tab was missing default values, NOT NULL and owner statements, all added. * There was a header color issue on some grids if you selected odd window schemes like "Pumpkin", now fixed. * Some objects where not showing comments in the dbexplorer list view. * Comment for function was not working,fixed. ***** Build 1027 March 2nd 2006 ****** *Fixed a bug with the code completin that caused the cursor to jump to the begining of the line if Scroll Past EOL was check in the editor options. *Added a uninstall icon to the program files group ***** Build 1026 February 18th 2006 ****** *The rules tab on the table editor is now fully functional. *Fixed some issues with the type editor as reported by a user. *Type editor can now alter the types schema if on a 8.1 server. ***** Build 1025 February 18th 2006 ****** * Fixed some encoding issues as reported by a user. ***** Build 1024 February 13th 2006 ****** * Fixed a bug with the new sql error dialog color was incorrectly set to clmenubutton * If the function editor returns a error with a line context (8.1 only) you can click the go to error context button and the line with the error will be highlighted red * Added bookmark support to the function and query editor. You can right click and use the toggle bookmarks or goto bookmarks or ctrl-shift {1..0} will toggle and ctrl-{1..0} will goto the bookmark. Bookmarks can help you find your place in large functions or sql scripts. ***** Build 1022 February 8th 2006 ****** * Added a right click option in the table editor to copy field names to the clipboard as a select statement. * Fixed a issue with the new function dialog where if on 8.1 the mode column would not be visible. * Fixed a couple of minor bugs ***** Build 1021 February 6th 2006 ****** * Added a Rules tab to the view editor per user request. The tab shows rules assigned to the view and allows adding,editing and dropping of rules assiged to the view. The table editor will recieve the same as soon as time allows. ***** Build 1019 January 31st 2006 ****** * Fixed a issue with the code completion that was caused by fields that had caps etc. replaced the pos function with fastposnocase to avoid any capitalization issues ***** Build 1018 January 30th 2006 ****** * Fixed a issue with the shift-ctrl-i shortcut for block indent,basicly it did not work because of a shortcut conflict. * Add a block size spin edit to the environment options. Block indent/undent used the same size as the tab. * Removed the show gutter option from the environment options main tab, as it was also in the gutter tab. * Added hints to all the editor options show on the environment options dialog. ***** Build 1017 January 23rd 2006 ****** * Table creation dialog was missing the option to use inherited tables. * Table editor DDL tab now shows if the table is using inherited tables. * Table editor DDL tab now shows table and column comment definitions. * If you are running version 8.1 or greater you can now see database,tablespace and tables sizes in the properties tab of each object respectively. the size is human readable formated. * changed the setup and application icon to something more Postgresql like. ***** Build 1016 January 21st 2006 ****** * Found and fixed a issue where the PK and FK icons would be shown on fields that where not a PK or FK. This issue would only show itself if you had more than one column defined and if the column numbers where greater than 9. The same applied if you had more than 1 FK defined and if they were on columns greater than 9. ***** Build 1015 January 19th 2006 ****** * Added a right click context option to truncate a table(dire warnings are given of course :-) * Added a option to drop all fields and truncate the table. * You can now import from MS Access into a newly created table with no fields and the structure will automaticly be recreated(including primary keys and indexes). This will also work on text files that have the field names as the first row. * Fixed a couple of bugs where the tab caption would not decrement the count when a field was dropped. * Other minor bug fixes. ***** Build 1014 January 16th 2006 ****** * Added icons to several forms that were missing them(backup,restore,trigger,field) * Fixed a typo in the query editor that caused a error when doube clicking on a column header. * Text fields can be viewed in the blob viewer * Fixed a issue where the function structure that was created with the new function dialog was not the same as that returned by the server, each param is now on it's own line, with 8.1 this was required for readability. ***** Build 1013 January 13th 2006 ****** * Fixed a bug where you could not drop a field from the table editor. caused by a typo in the code. * Fixed a bug where the boolean/bool type would not show up in the field editor type combo text field. ***** Build 1012 January 10th 2006 ****** * The rules tab on the table editor now shows the rules for the table and the comment for each rule. You currently can't edit the rules, but that should be available in the next update. * Fixed a small bug where a error would be generated if you clicked the data tab on a table that did not have any fields. ***** Build 1011 January 7th 2006 ****** * Fixed a small issue with the right click on the MDI tabs for closing. * Fixed a small issue where the grant manager would not open, this was a artifact of converting the code to Delphi 2006. * You can now close tabs by using the middle mouse button/wheel button ***** Build 1010 January 5th 2006 ****** * Fixed a nasty bug that involved the view editors. Prior to Delphi 2006 the memory manager never reported the memory leak that was occuring. The new memory manager did not like the phantom view forms that where being created this could cause a AV and very weird errors. * Enhance the tab menu merge with the main menu, should be much smoother. ***** Build 1005 January 2nd 2006 ****** * Added a "Check for new version" item to the help section of the main menu. Clicking this new option will cause a http connection to be initated against a version file on the amsoftwaredesign website. If your version is less than the version listed in the file a messagebox will inform you of the new version number and show you the change history in a tab. You will also be given the option of downloading the latest setup.exe via your default web browser. ***** Build 1004 January 1st 2006 ****** * Fixed a issue where the right click on a data grid column header was not showing the header menu. * fixed a issue where the data grid's cell right click was not working correctly, it was not showing the text cut/copy/paste menu when a cells text was selected. Right clicking on a unselected cell will show the popup menu with the import/export options and entire cell cut/copy/paste and select/unselect all. ***** Build 1002 December 21st 2005 ****** * SQL,Function and view editors are now UNICODE enabled by using UniSynedit. * Fixed a bug where the database client encoding was being forced to UNICODE, no matter what encoding the database was created with. This caused problems with encodings such as WIN1250 and probably others. * We are working towards adding as much UNICODE support as possible, If there is a area you need with UNICODE support please let us know. The only thing as of right now that can't be UNICODE enabled is the Devexpress grids, but we provide a standard DB grid that is UNICODE enabled, you just need to switch to the Unicode Grid view. * Added a right click option to the SQL editor to clear all text. * Added right click cut/copy/past to the table editors comment tab. * Fixed a issue where right clicking on the query editor grid would cause a AV * Fixed a issue where the grid data import button would not work on a empty table (it was a copy/paste error from the export code,where the record count must be > 0 to export) * Added a right click copy option to the table editor DDL tab. ***** Build 992 December 12th 2005 ****** * Fixed a issue where a newly created database would not show it's properties in the Enterprise Manager property list view. * Fixed a bug where a newly created database could not be dropped until a restart of the application. ***** Build 986 December 11th 2005 ****** * If you are running 8.1 the server status now shows the IP and port of the PID * Server status shows global locks(this is just initial support for show locks) * Changed the MDI tab page index on close to go from right to left, also if you close the last tab it will not jump to the first tab. * Query builder was not adding tables when dragged and dropped because the original tlistbox was switched to a tcxlistbox and this caused problems with typecasting. Solution was to switch back to tlistbox. ***** Build 981 December 9th 2005 ****** * Added object counts to the table editor tabs, you can now see if there are any indexes,contraints etc without having to actually open the tab. * The table editor's comment tab will be lower case if their is no comment present and upper case if one is present. * Fixed a issue where the form view edit controls would lose focus if the mouse moved off of the edit box, this caused selected text to be unselected because it lost focus. * Fixed a AV that would occur if you closed a database and elected to close all open forms from the dialog box * Changed the table editor's Description tab to say Comment instead to match property viewer list view. * Added a "restore database" right click option to the databases nodes, you can now restore into a freshly created database without having to open it first. * Set the server status tab to only open one instance per server(this was broke after switching to the tabbed interface) ***** Build 976 December 8th 2005 ****** * Added the ability to reorder the MDI tabs via drag and drop * Changed plink.exe (used for ssh support) to pgla_link.exe so as not to interfere with plink.exe that may already be installed on a users PC. * implemented a procedure on startup that will kill any pgla_link.exe that my be still around after a application crash or if the application is killed from the task manager. ***** Build 972 December 7th 2005 ****** * Fixed a issue with the new MDI implementation where the toolbar hints/hightlighting and the customize dialog failed. * Fixed some issues with the close all for the MDI tabs(Dev Express updates broke some code with the page control). ***** Build 961 December 6th 2005 ****** * Updated Devexpress components to latest service packs * Added the ability to edit a columns default value in the table editor grid. * Added the ability to change a columns NOT NULL status from the table editor grid. * Changed the Enterprise Manager's splitter to have a minumum value of 2 (was at one) ***** Build 951 December 3rd 2005 ****** * Fixed a bug where the tree was being refreshed each time the function was saved to the server, it should have been refreshed only if the function was new. * Added the table name to the tab caption for the quickview data option. * Added the sql wait cursor to the quickview data process. * Fixed a bug where the "Close All" option for the MDI tabs would fail if you had a quickfiew form open. ***** Build 950 November 30th 2005 ****** * Fixed a bug that caused Foreign key creation to fail when the referenced table had caps. * Fixed a issue with captitals and the run function command. * Added a spiffy startup splash screen. * Updated about form to match splash screen. * Added hyperlinks to the about form. * Added a link to the support forums under the main help menu. * Added a link to request a support ticket under the main help menu. ***** Build 945 November 29th 2005 ****** * Added tabbed MDI right click context menu item for "Close All" and "Close All (Except Active)" * Added Query Builder button to view editor. ***** Build 943 November 23rd 2005 ****** * Standard MDI system replaced with tabbed based MDI system. The old MDI system has been deprecated by MS in favor of this type of MDI. PGLA now shows documents much like the way VS 2003-2005 and Delphi 2005 do. * Fixed a issue where indexes and constraints that had upper case chars could not be dropped. * Fixed a cut/copy paste issue with the function description tab on the function editor. * Fixed a issue where the server status monitor would be disconnected if you single clicked on a database node in the tree. * Updated CHM help file. Thanks to Michael Schmidt for helping with new content. * Updated Postgresql documentation to 8.1 ***** Build 934 November 9th 2005 ****** * Added maintenance dialog, you can now vacuum,anaylze and reindex whole databases or individual tables via right click or the maintenance tab on the table editor. * Fixed a issue with the blob viewer where selecting a image type with a empty blob would cause a error to be raised. * Fixed a bug with the status monitor that would cause many dialog boxes to be spawned if the connection was closed while monitoring was in progress. ***** Build 930 November 2nd 2005 ****** Added the ability to change the font for the main data grids and the table editor grids. This should allow the main grid to view some unicode data by changing the font. ***** Build 929 November 1st 2005 ****** * Added a return bottom option to the quick data viewer * Added a comment tab to the database object properties tab * Fixed a bug in the query builder relating to object name qouting ***** Build 928 October 24th 2005 ****** * Fixed a access violation when switching to the form view in the query editor when no data was available * Fixed a issue with renaming when the object name was a Postgresql reserved word such as user (this mainly seemed to affect 7.4.x databases). * Added support for 7.4.x databases, PGLA is now quite usable with 7.4.x * Fixed a issue with the code completion where the word TRIGGER FUNCTION would over write the second column. * Fixed a issue where viewing data against tables named with reserved words failed. * Fixed a issue where the sequence editor would not display/save a comment. * Fixed a issue in the constraint grid where focus was always being set to the first row. * Added a cancel option to the save on close dialogs * Updated the embedded pg_restore and pg_dump to version 8.1. * Updated libpq.dll to version 8.1. * updated openssl dlls to version 0.9.8.0. * Added shared file flag to system dlls in installer.