This repository has been archived by the owner on Sep 15, 2022. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
CHANGELOG.txt
302 lines (263 loc) · 13.8 KB
/
CHANGELOG.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
1.6.x
-----
Only set font for output-displaying controls.
Add Hot Key in SQLOutput
add Show Users For Privileges
add Ask Delete Object Database
add description connection
add Max number of record for view data.
add Max number of sql command to memorize (Query).
add new visual query builder
Display Operator details correctly [Hiroshi Saito]
Fixed reserved word quoting.
add operator class (create,drop,clone,find)
add Load/Save/F5 execute/F4 clear Query in visual query builder
add support multi language (extract string from source, merge file language)
add editor language
Fix reservation word with QUOTE. [Hiroshi Saito]
1.6.0
-----
Behave nicely if the logfile cannot be opened.
Correctly delete records in some circumstances when they haven't been editted first and the primary key is not the first column.
Fix a bug in the Access Exporter that caused a crash when there was only 1 record to export [Frank Lupo].
Fix select on operator when loading after adding a new one [Frank Lupo].
Add drop object using cancel key [Frank Lupo].
Add function node on trigger [Frank Lupo].
Fix AutoSizeColumnLv if element of listview is zero [Frank Lupo].
Fix clone CloneFunction [Frank Lupo].
Move highlight words to Keywords.txt and use for quoting as well [Frank Lupo].
Set default schema to public in edit grid [Frank Lupo].
Don't allow reseting of statistics with PostgreSQL < 7.3 [Frank Lupo].
Don't warn the user about vacuuming in use tables for PostgreSQL >= 7.2.
Create objects correctly when their parent node isn't yet created.
Import fixed length columns correctly.
1.5.60
------
Refresh comment cache after editting views.
Decode trigger procedure parameters correctly.
Fixed a bug in Domain counting code.
Fixed a bug in the Foreign Key analysis code that occured with multiple foreign keys to the same table.
Added combo box of available variables to frmDatabase/frmUser [Frank Lupo].
Added 'Show current settings' option for frmDatabase [Frank Lupo].
Quote database & user variable values correctly.
Fix ADO crash when accessing binary columns in the data grid.
Added support for Casts [Frank Lupo].
Added 'Find Object' [Frank Lupo].
Autosize listview columns [Frank Lupo].
New custom error dialogue [Frank Lupo].
Added MS Access Exporter [Frank Lupo].
Added a pg_hba.conf editor plugin [Frank Lupo, Mark Yeatman].
Additional User/Database variable handling code including combo boxes for known options [Frank Lupo].
Added an option to reset statistics [Frank Lupo].
User definable row limit when viewing large tables/rows [Frank Lupo].
Added command history to the SQL dialogue [Frank Lupo].
Allow F5 to execute SQL queries.
Limit statistics to the correct schema [Frank Lupo].
Allow numeric usernames in groups.
Added a dialogue to allow column definition to be copied from another table in Create Table dialogue [Frank Lupo].
Allow scroll through objects in property dialogues [Frank Lupo].
Added Copy/Paste options for most object types [Frank Lupo].
Added support for Conversions [Frank Lupo].
Added support for rules on views [Frank Lupo].
Added support for dependency checking [Frank Lupo].
Fixed date handling in the Excel exporter.
Added support for Set Returning Functions [Frank Lupo].
Allow addition and removal of Foreign Keys post table creation [Frank Lupo].
Allow modification of column storage type [Frank Lupo].
Allow specification of array dimensions on new columns [Frank Lupo].
Updated PostgreSQL docs to 7.3.2.
1.4.12
------
Allow dropping of Rules correctly with PostgreSQL < 7.3.
Quote referenced columns in foreign keys correctly.
Corrected Refresh button tooltip in data viewer.
Allow Data Editor to set dates/timestamps to null when value is cleared.
Fixed a bug in the View update code.
Fixed a bug in Explain Plan with PostgreSQL 7.3.
Fixed a bug in the SQL query parser that failed to handle table/view names containing spaces correctly.
Added support for multiple foreign keys on one table with the same name.
Allow View Data of tables/views in schemas with quoted names.
Retrieve new function details correctly after creation in PostgreSQL 7.3.
Fix issues in SQL generation for Triggers, Indexes and Rules when Schemas are applicable.
Added support for SECURITY DEFINER functions.
Allow quoted schema/table names to work correctly in the SQL wizard.
Updated PostgreSQL docs to 7.3.
1.4.2
-----
Fix annoying initialisation bug in frmView that prevented viewing View details.
Fix highlighted texbox background colour in data editor.
Display Element Type in Type properties correctly.
1.4.1
-----
Allow viewing of data in Tables and Views not in the schema search path.
1.4.0
-----
Don't shutdown on error when incorrectly setting a column default.
Don't get hung up on errors in the comment cache.
Reference OID columns as rs.Fields("oid") not rs!oid to get around an MDAC/case mangling bug in some locales.
Allow the use of numeric only usernames.
Updated PostgreSQL docs to 7.3rc1.
1.3.82
------
Attempt to capture all errors, not just the last.
1.3.76
------
Fixed a bug that attempted to access inaccessible databases when clicked on in the treeview.
Use doubles instead of longs to cope with very large OIDs.
Fixed a bug that caused an error if the pgAdmin window was too small when the listview was populated.
Don't class 'public' as a system schema.
Don't throw an error when changing Not Null/Primary Key on a new column in an existing table.
Don't allow (attempted) alteration of certain column attributes in PostgreSQL 7.2.
Fixed some errors in the function editor.
Raise errors properly from pgSchema.
Only quote identifiers in datagrid update queries when required.
Allow use of numeric identifiers.
Fixed a bug that prevented renaming columns.
Fixed an error that occured when clicking on the Relationships node under a Foreign Key.
Fixed a bug that prevented updating of Sequence values.
Display object counts in the treeview immediately now we know them in advance.
Handle dates/time formats supported by Windows, not just those supported by PostgreSQL (particuarly those that use . seperators)
Allow use of F5 to execute SQL queries (Andy Kelk).
If SQL is highlighted in the SQL textbox, execute only that, not the whole query (Andy Kelk).
Fixed a bug where an SQL file got overwritten if the user clicked 'Cancel'.
Added DROP COLUMN support (Wahoo!).
Don't display ON UPDATE/ON DELETE clauses in Foreign Keys if unspecified.
Fixed broken error handling in pgSchema.
1.3.60
------
New resize code in frmMain - allows adjustment of the Listview/Definition pane split.
Fixed a bug where selecting privilege ALL did not disable the Rule privilege.
Hide System Objects in the SQL Wizard.
Updated icons.
Added Refresh button to DataGrid.
Added Select All/Select None buttons to potentially large listviews.
Simplified Listview handling code.
Reworded text on encrypted passwords in frmOptions.
Added Query Log Recorder.
Fixed a bug that cleared default values instead of updating them.
Check the PostgreSQL version when connecting and handle correctly.
Updated the PostgreSQL docs to the 7.2 Release version.
Clear Upgrade Wizard listview before populating.
REVOKE privileges from groups correctly.
Allow creation of tables with no columns, just inherits.
Don't include inherited columns & checks in table definitions.
Fixed a bug in the Import Wizard data parser.
Fix mouse pointer and allow display of errors when timer is stopped (Mark A. Taff).
Fixed a bug in the query parser in the SQL output grid.
Allow pseudo modification of views with PostgreSQL 7.2+
Views can now be renamed.
Fixed a bug in the trigger reverse engineering that prepended the execution conditions of previous triggers to the current.
Added an option to enable or disable Auto Row Counts.
Added Rows property to View objects.
Set default database encoding to "SQL_ASCII".
Quote function definition when needed.
Fixed a bug that prepended a carriage return when loading SQL queries from file.
Added AllowConnections property to database objects, display it in pgAdmin, and check it before attempting to connect to a database.
Invalidate Caches before refreshing hierarchy in pgSchema.
Standardised db name access method throughout pgSchema's classes, and added caching.
Added support for renaming Sequences & Indexes.
Added a '-wine' command line option to disable modal dialogues (they don't seem to work under Wine).
Prevent connection to databases until they are selected. Added an option to revert to old behaviour.
Added support for dropping checks with PostgreSQL 7.2+.
Excel Exporter: Format the cell for the data type & inserts the data using the cells 'FormulaR1C1' property (David Horwitz).
Allow selection of font for display of data.
Added a guide to setting up a development environment.
Added a HOWTO on using MD5 Encrypted Passwords.
Added support for viewing statistics on PostgreSQL 7.2+
Cancelling closure of child windows will now cancel application exit.
Allow sorting of listview/statsview by clicking the column headers.
Use Primary Keys for updating/deleting rows in the data editor where possible.
Fix EXPLAIN for PostgreSQL 7.3+
Added support for Domains in PostgreSQL 7.3+
Enhanced the query parser to detect queries with functions and subselects in the column list, and aliased columns as non-updateable.
Quote sequence names properly when using setval.
Treat all objects named pgadmin_* as system objects.
Fixed a bug in the Operator Cache which also cached the left & right types.
Allow addition & removal of NOT NULL constraints on columns with PostgreSQL 7.3+.
Check the ODBC driver version correctly for EXPLAIN.
Added support for Schemas in PostgreSQL 7.3+.
Removed Revision Control due to it's complexity and lack of use following an RFD on the hackers and support lists.
Rewrote the code that associates treeview nodes with pgSchema objects. The new code is faster and more reliable.
Correctly recognise functions with one opaque argument.
Filter functions listed when creating Types & Operators to only those that are suitable.
Only quote identifiers when required.
Allow addition and removal of Primary Keys with PostgreSQL 7.3+.
Allow renaming of Triggers in PostgreSQL 7.3+
Added support for configuration of user & database config variables with PostgreSQL 7.3+
Added support for Array datatypes.
Added support for ACLs on Databases, Languages & functions with PostgreSQL 7.3+.
Allow display & updating of column statistics values with PostgreSQL 7.2+.
Allow use of language validators with PostgreSQL 7.3+.
1.2.0 Stable
------------
Allow use of new serial8 type.
Warn user that serial-created sequences & indexes must be manually committed to Revision Control.
Tweak efficiency of the Comment cache in pgSchema (~30% faster population of cache).
Distribute non Win2K riched32.dll.
Update other column properties before renaming for safety.
Set Unknowns As LongVarChar when connecting to allow ACLs > 255 characters.
Added features list to help.
Added bugs and to-do lists to help menu (missing for some reason).
Added release procedure to help.
Fixed a typo in the licence.
Updated Copyright notices to include 2002.
1.1.76
------
Don't reformat SQL queries as that can corrupt PL scripts.
Clear Relationships/Referenced Columns when selecting a new Referenced Table when defining a Foreign Key.
Correctly escape single quotes & backslashes in function code.
Print function source nicely in the properties listview.
Set MAX_VARCHAR_LENGTH to 64Kb so we don't truncate long functions etc.
Allow double-clicking of items in the listview.
Display some missing Server Properties in the listview.
Switch on Commlog/Mylog when loglevel is high enough.
Added SSH Tunneling HOWTO from Fred Yankowski.
Fixed the Highlightbox control so it doesn't strip braces {} from text.
Added support for PostgreSQL 7.2 style ACLs (seperated Update/Delete, added References & Trigger) in the Security Wizard.
Support 64Bit sequences properly on PostgreSQL 7.2+
Added Revision Control HOWTO to Help.
Added Links page to Help.
1.1.72
------
Fixed a bug in the row identification code in the Edit Grid when deleting records.
Added a Cancel option to the Save SQL Query? prompt.
Fixed a bug in the Import Wizard which failed if not all the available target columns were selected.
Fixed a bug that prevented dropping of triggers.
Fixed a bug that prevented dropping of Users & Groups.
Fixed a bug that prevented dropping of Users or Groups with single quotes in their name.
Added support for PostgreSQL 7.2 style ACLs (seperated Update/Delete, added References & Trigger).
Updated PostgreSQL documents to the 7.2b4 version.
Load SQL scripts sensibly to prevent crashes with large scripts.
Quote column names correctly in Foreign Key definitions.
1.1.66
------
Added new graphics.
Fixed a bug where an error was generated when clicking a Foreign Key 'Relationships' node in the treeview.
Fixed a bug in the row identification code in the Edit Grid.
Perform a Machine based install rather than user based if possible.
Added PostgreSQL 7.1.3 Documents to the CHM helpfile.
1.1.59
------
Added comprehensive Revision Control system.
Added support for PostgreSQL 7.2 OID-less tables.
Added support for PostgreSQL 7.2 Encrypted passwords.
Added support for PostgreSQL 7.2 Partial Indexes.
Functions can now be editted with PostgreSQL 7.2+.
The Master Connection Database can now be changed if template1 is not available.
Fixed a bug in the SQL generation of tables with char columns.
Unavailable menu options/buttons are now disabled instead of hidden.
Added a Database Publishing Wizard that publishes from staging to production servers.
1.1.34
------
Fixed a bug in the SQL generation when creating tables with multiple foreign keys
Added type 2 plugin support (this allows plugins that are available before a server connection is made).
Added some connection debugging tools.
1.1.28
------
Fixed a bug where the hourglass was displayed as soon as an exporter was loaded.
Added a Data Import Wizard
1.1.26
------
Added 'Tip of the Day'
Added an Upgrade Wizard
Fixed a bug preventing the use of objects whose names differed only in case.