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 83
/
CHANGELOG
1435 lines (1426 loc) · 89.3 KB
/
CHANGELOG
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
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
pgAdmin III Changelog
=====================
Notes
-----
This is the pgAdmin III changelog. Items are marked with the initials of the
developer responsible for them, and the version of pgAdmin that the change
will first appear in. For convenience, changes during Beta and RC phases may
include an RCx or Bx suffix on the version number, but for simplicity these
will not normally be retained.
A name in square braces [Joe Bloggs] indicates that the change was written by
Joe. The initialed developer was responsible for reviewing the changes in these
cases.
Names shown as "per Joe Bloggs", indicate that Joe reported the problem and may
have provided help debugging it, but did not actually provide the change.
Key to developers
-----------------
- DP Dave Page
- AP Andreas Pflug
- JMP Jean-Michel Poure
- HS Hiroshi Saito
- AHP Adam H. Pendleton
- MP Marc Persuy
- DAP Darko Prenosil
- FGP Florian G. Pflug
- MH Magnus Hagander
- GL Guillaume Lelarge
Changes
-------
Date Dev Ver Change details
---------- --- ------ --------------
2010-06-02 AV 1.10.4 Fix the ever-displayed message when modifying multiple
times the same object (occurs with exttable, function,
package, trigger, per a report from Peter Geoghegan.
2010-05-27 AV 1.10.4 Use CALL to execute callable statements, not PERFORM.
2010-05-21 AV 1.10.4 Drop package bodies correctly if they only contain
whitespace.
2010-05-21 AV 1.10.4 Fix a typo in the stored procedure debugger invocation
code block.
2010-05-21 AV 1.10.4 Fix debugging of functions by non-superusers in PG again.
2010-05-18 GL 1.10.4 Fix the editing of date and time values in the edit
grid, per a request from Paul Hughes.
2010-05-14 GL 1.10.4 Fix the function's generated query for TABLE-returning
functions.
2010-05-10 GL 1.10.3 Fix the "quiet log" query in the status server.
2010-05-07 AV 1.10.3 Call Stored Procedures in EnterpriseDB in an anonymous
block to prevent errors with out/inout parameters.
2010-05-07 AV 1.10.3 Fix an error when working with packages on EnterpriseDB
in 'postgres' mode.
2010-05-07 AV 1.10.3 Prevent a crash if the user cancels a restore operation.
2010-05-05 GL 1.10.3 Fix the refresh of a dropped function.
2010-04-29 AV 1.10.3 Fix a crash bug seen when closing the debugger parameter
dialog on OSX.
2010-04-28 GL 1.10.3 Fix to only show Storage value if the value is
different from the type's default value, per a
suggestion from Erwin Brandstetter.
2010-04-28 GL 1.10.3 Fix uncalled attempt to "change" array data types in
dlgColumn, per a report from Erwin Brandstetter.
2010-04-27 DP 1.10.3 Fix a crash that could occur if viewing a table with
no rows in the Edit Grid [Ashesh Vashi].
2010-04-26 DP 1.10.3 Fix a crash occuring when a function with a parameter
with a default is selected [Ashesh Vashi].
2010-04-22 DP 1.10.3 Don't offer debugging options to non-superusers on
Postgres Plus Advanced Server < 8.4 which doesn't
have support for user debugging [Ashesh Vashi]
2010-04-21 GL 1.10.3 Fix the saving and reverse engineering of parameters for
database, table, and function, according to a report
from Erwin Brandstetter.
2010-04-20 GL 1.10.3 Specify the schema of the table/function to restore if
pg_restore's release is 8.2 or later, per a report from
Kieran McCusker.
2010-04-20 GL 1.10.3 Fix the reverse engineering of a rule.
2010-04-16 GL 1.10.3 Fix the status server window on Mac OS X, per a report
from Dave.
2010-04-16 GL 1.10.3 Fix the recent files, by notifying each frmQuery to
update their recent files. Same support for macros and
favourites. Per a report from Josh Berkus.
2010-04-15 GL 1.10.3 Fix the canvas resizing with really big table, per a
report from Michael Haltrecht and a patch from Ashesh
Vashi.
2010-04-10 GL 1.10.3 Add the missing RULEs for VIEWs in SQL pane, per a
report from Erwin Brandstetter.
2010-04-06 GL 1.10.3 Add groups in the owner combobox, per a report from
Erwin Brandstetter.
2010-04-03 GL 1.10.3 Get back to the Properties tab when a user connects to
a server.
2010-04-03 GL 1.10.3 Fix the reverse engineering of a table when its columns
have Storage or Statistics value, per a report from
Erwin Brandstetter.
2010-04-03 GL 1.10.3 Correct reverse engineering of a function that RETURNS
TABLE, per a report from Erwin Brandstetter.
2010-04-02 GL 1.10.3 Display the tablespace in the reverse-engineered SQL of
the database.
2010-03-25 GL 1.10.3 Make sure "Use Replication" is visible even with a big
comment on an column.
2010-03-25 GL 1.10.3 Prevent a crash on the GQB when someone right click to
delete a join rather than properly select it
2010-03-20 GL 1.10.3 Make sure that Statistics tab doesn't shows more
databases than Properties tab
2010-03-19 DP 1.10.3 Warn the user if a file couldn't be opened because it
contains invalid characters [Ashesh Vashi]
2010-03-16 DP 1.10.3 Fix command line quoting for backup/restore [Ashesh
Vashi].
2010-03-10 DP 1.10.3 Avoid a crash when debugging NULL procedures [Ashesh
Vashi].
2010-03-04 GL 1.10.2 Correctly save the position of a pgFrame, per a report
from Andreas Laggner and Dan Halbert.
2010-02-16 GL 1.10.2 Fix the reverse engineering of a function, per a report
from Kieran McCusker.
2010-01-23 GL 1.10.2 Fix the xmlTextWriterEndDocument check when saving a
favorite.
2010-01-20 GL 1.10.2 Fix an SQL error when changing a parameter for a
database, role/user and a function.
2010-01-10 GL 1.10.2 Fix the display of a type with a specific typmod.
2010-01-10 GL 1.10.2 Select the server choosen with the /s command-line
argument.
2010-01-10 GL 1.10.2 Fix the call to the Slony-I storenode function.
2010-01-10 GL 1.10.2 Fix display of the date/time chooser.
2009-12-03 GL 1.10.1 Replace Alt-F4 with Ctrl-Q and Ctrl-W.
2009-11-26 DP 1.10.1 Prevent a crash if the edit grid is closed whilst it
is loading data.
2009-11-25 DP 1.10.1 Don't attempt to remove rows in the edit grid if the
user presses the delete key when the delete button is
disabled.
2009-11-23 DP 1.10.1 Only offer valid server encodings for new databases
[Quan Zongliang]
2009-11-20 DP 1.10.1 Fix font dialogue on Snow Leopard.
2009-11-16 GL 1.10.1 Fix an issue with the ordering of the mappings in a
text search configuration.
2009-10-21 DP 1.10.1 Fix a potential crash bug in the object browser.
2009-10-13 DP 1.10.1 Reverse engineer empty (not NULL) ACLs correctly.
2009-10-08 DP 1.10.1 Fix Greenplum support for column oriented partitions
[Chuck McDevitt]
2009-10-05 DP 1.10.1 Ensure function variables get reset if the function is
modified, per Dmitry Samokhin.
2009-10-01 DP 1.10.1 Fix cluster creation for Slony 2.0 [Sachin Srivastava]
2009-09-24 GL 1.10.1 Reverse engineer function defaults values correctly.
2009-09-01 DP 1.10.1 Fix a potential crash in the edit grid.
2009-09-01 DP 1.10.1 Fix domain creation/modification for domains in
non-default schemas.
2009-09-01 DP 1.10.1 Reverse engineer language privileges correctly [Sachin
Srivastava].
2009-08-10 GL 1.10.1 Get rid of "No SQL query was generated." message dialog
when no tables are selected in the GQB, per request
from Rainer Bauer.
2009-08-10 GL 1.10.1 Hints files should be encoded in UTF-8.
2009-08-04 DP 1.10.1 Include comments on procedures in the reverse engineered
SQL.
2009-07-30 DP 1.10.1 Fix debugger name resolution on 64 bit Solaris.
2009-07-30 DP 1.10.1 Fix Slony cluster creation on Solaris.
2009-07-30 DP 1.10.1 Fix foreign key creation on Solaris.
2009-07-29 DP 1.10.1 Fix an SQL syntax error when viewing the dependencies of
a sequence [Ashesh Vashi].
2009-07-24 GL 1.10.1 Fix macros writing, per report from Mauro Bertoli.
2009-07-24 GL 1.10.1 Better fix for schedule and step dialogs.
2009-07-24 GL 1.10.1 Fix the menu entry in frmQuery, per a report from Luiz
K. Matsumura
2009-07-20 GL 1.10.1 Fix the dlgFunction handling of preload libraries, per
report from Michael Shapiro.
2009-07-19 GL 1.10.1 Fix schedule and step dialogs [Ashesh Vashi, Guillaume
Lelarge].
2009-07-01 DP 1.10.1 Fix error thrown when examining a Slony 2.x cluster.
2009-04-01 DP 1.10.0 Add support for RETURNS TABLE() on functions [Ashesh
Vashi].
2009-04-01 DP 1.10.0 Fix the validation of database and schema restriction
strings.
2009-03-31 DP 1.10.0 Support ldap, gss, sspi & cert authentication methods in
the pg_hba.conf editor.
2009-03-27 DP 1.10.0 Remove the 'use tab key for autocomplete' option as it
breaks other editor features for little gain.
2009-03-19 DP 1.10.0 Ensure that dependencies between tables and sequences
used by serial columns are displayed properly [Ashesh
Vashi].
2009-03-10 DP 1.10.0 Enhance support for Greenplum - add resource queue,
external table and partitioned table support. Teach
the graphical explain tool about Greenplum query node
types, add Greenplum help and utility support [Chuck
McDevitt].
2009-02-27 DP 1.10.0 Fix handling of aggregate initial conditions to allow
NULL or empty strings to be specified.
2009-02-27 GL 1.10.0 Allow the contents of the panes on the Server Status
window to be copied to the clipboard.
2009-02-26 GL 1.10.0 Complete UI rework of the "Server Status" Window.
2009-02-23 DP 1.10.0 Add support for per-table TOAST autovacuum settings in
PostgreSQL 8.4+ [Ashesh Vashi].
2009-02-18 DP 1.10.0 Add support for per-table autovacuum settings in
PostgreSQL 8.4+ [Ashesh Vashi].
2009-02-13 DP 1.10.0 Fix support for 'bit varying' columns [Quan Zongliang].
2009-02-03 DP 1.10.0 Add support for column level privileges on PostgreSQL
8.4 and above [Ashesh Vashi].
2009-01-13 DP 1.10.0 Warn the user if connecting to a newer version of the
server than is supported.
2009-01-12 DP 1.10.0 Add support for Window functions [Ashesh Vashi]
2009-01-09 DP 1.10.0 Add an option to ignore server version mismatches with
pg_dump/pg_dumpall/pg_restore.
2009-01-08 DP 1.10.0 Add support for default values for function parameters
in PostgreSQL 8.4+ [Ashesh Vashi]
2009-01-08 DP 1.10.0 Restore old behaviour of the Edit Grid where <return>
moves to the next column, but <enter> moves to the next
row rather than both changing column [mei ben]
2009-01-07 DP 1.10.0 Add support for direct debugging of functions with
variadic parameters.
2009-01-05 GL 1.10.0 Add -S and -Sc command line options to open a server
status window
2009-01-01 DP 1.10.0 Add support for the many new node types in Postgres 8.4
[Ashesh Vashi]
2008-12-31 GL 1.10.0 Add CONNECTION LIMIT support for roles (8.1+).
2008-12-29 DP 1.10.0 Allow pgAgent to connect to databases on remote servers,
such as hot standby machines [Ashesh Vashi]
2008-11-25 DP 1.10.0 Add support for DESC and NULLs FIRST/LAST options for
index columns [Quan Zongliang].
2008-11-18 DP 1.10.0 Add support for per-database collation, ctype and
connection limits [Ashesh Vashi]
2008-11-14 GL 1.10.0 Add ALTER DATABASE SET TABLESPACE support (8.4)
and re-adds ALTER DATABASE RENAME TO support.
2008-11-07 DP 1.10.0 Fix the index UI to handle columns with commas in the
name [Quan Zongliang]
2008-11-04 DP 1.10.0 Remove the un-maintained Tip of the Day feature [Ashesh
Vashi]
2008-10-27 GL 1.10.0 Add more index stats.
2008-10-13 DP 1.10.0 Fix the edit grid to work with bit(x).
2008-09-15 MH 1.10.0 Add pgScript scripting framework [Mickael Deloison - GSoC]
2008-09-08 DP 1.10.0 Add support for variadic functions in PostgreSQL 8.4+.
2008-09-04 DP 1.10.0 Ensure we never try to refresh the Servers node.
2008-09-01 DP 1.10.0 Don't fetch temp schemas if not actually required, as
Greenplum seems to generate thousands in some
circumstances.
2008-08-30 GL 1.10.0 SQL text field can be enabled to allow SQL changes on
properties dialog.
2008-08-26 GL 1.10.0 Review of the dialogs to make them growable.
2008-08-22 DP 1.10.0 Add options to shift selected text to upper or lower
case in the SQL editor.
2008-08-22 DP 1.10.0 Add block commenting and uncommenting to the SQL editor.
2008-08-21 DP 1.10.0 Add block indenting and outdenting to the SQL editor.
2008-08-20 DP 1.10.0 Prevent the auto complete in the query tool being used
while a query is running.
2008-08-19 DP 1.10.0 Graphical query builder [Luis Ochoa - GSoC]
2008-08-11 GL 1.10.0 Support for FTS objects.
2008-08-11 GL 1.10.0 Support for adding/removing inherited tables with 8.2+
servers.
2008-07-04 GL 1.10.0 Don't display SQL tab on Server properties dialog.
2008-07-04 DP 1.10.0 Ensure a newline is included between notices in the query
tool.
2008-06-20 DP 1.10.0 Save and restore the user-selected line ending type in
styled text controls.
2008-09-18 MH 1.10.0 Avoid running excess queries on pg_shdescription when
connecting to a server, fixing performnce regression
with large number of databases.
2008-06-20 DP 1.10.0 Ensure that line endings stay consistent when editing in
styled text controls.
2008-06-11 DP 1.10.0 Fix listing of group roles in the combo box on privilege
panels.
2008-06-10 DP 1.10.0 Reverse engineer multi-word type names correctly when
quoting.
2008-06-04 DP 1.8.4 Fix potential crash bug in the query tool logging code,
per Erwin.
2008-05-30 DP 1.8.3 Allow comments to be edited on EDB stored procedures.
2008-05-29 DP 1.8.3 Fix comments on EDB packages.
2008-05-29 DP 1.8.3 Ensure the grant wizard works correctly with EDB stored
procedures.
2008-05-28 DP 1.8.3 Ensure functions in databases with non-ASCII names can be
debugged.
2008-05-27 DP 1.8.3 Allow a debugging session to be cancelled correctly on
windows.
2008-05-23 DP 1.10.0 Allow the treeview nodes to be colour-coded for each
server, per Michael Glaeseman.
2008-05-19 DP 1.10.0 Allow external utilities such as pg_dump & pg_restore to
work with SSL connections.
2008-05-19 DP 1.10.0 Add support for pg_restore's --clean option.
2008-05-16 DP 1.10.0 Allow default settings to be set via a global config
file. This allows redistributors and sysadmins to
pre-configure an installation as required.
2008-05-15 DP 1.10.0 Add support for TRUNCATE triggers on PostgreSQL 8.4+.
2008-05-06 DP 1.10.0 Auto-discover Postgres Plus servers on Mac and Unix.
2008-05-06 DP 1.8.3 Fix a corner case in which closing the debugger window
following a failed attempt to create a global breakpoint
(for example, because of an existing breakpoint) could
cause a crash on Windows.
2008-05-06 GL 1.10.0 Add 8.2 and 8.3 stats columns to tables list.
2008-05-06 GL 1.10.0 Add owner's column to list of objects.
2008-05-06 DP 1.8.3 Store pgAgent job step result codes in an int4 column.
int2 was proving too small in some cases resulting in an
error.
2008-05-02 DP 1.8.3 Allow EnterpriseDB packages to be created without bodies.
2008-05-02 DP 1.8.3 Always refresh the data when the user clicks OK on the
edit grid options dialogue to ensure the filter/sort is
applied to current data.
2008-05-02 DP 1.8.3 Prevent unsaved changes in the edit grid being lost if
the filter or sorting dialogue is opened.
2008-05-02 DP 1.8.3 Update node text when refreshing treeview nodes in case
part of the identifier has changed.
2008-05-01 DP 1.8.3 Correct config window help paths.
2008-05-01 DP 1.8.3 Don't load group roles and old-style groups on the
security tab on 8.1 and higher.
2008-05-01 DP 1.8.3 Correctly quote role names when reverse engineering ACLs.
2008-04-20 DP 1.8.3 Don't allow the user to attempt to remove columns from
an existing index or index constraint.
2008-04-08 DP 1.8.3 Disable the RULE privilege on 8.2+ for views per Erwin.
2008-04-04 DP 1.8.3 Fix the logging system to ensure that errors from the
query tool get logged, and notices are only output once.
Cleanup some other minor misbehaviours at the same time.
Per report from Erwin.
2008-03-27 DP 1.8.3 Ignore the type modifier for domains in function
signatures.
2008-03-22 DP 1.8.3 If stopping the server service fails after stopping
dependent services, wait 5 seconds and try again up to 10
times to allow the dependents time to shutdown fully.
2008-03-20 DP 1.10.0 Add a DELETE script option for tables [Rémi Flament]
2008-03-19 DP 1.8.3 Don't include the -h option when calling pg_dump or
pg_restore if there is no hostname to specify.
2008-03-18 DP 1.8.3 Convert setting names to lower case so we don't end up
with DateStyle and datestyle for example.
2008-03-11 DP 1.8.3 Construct SQL used to add columns such that the entire
operation happens in one statement to ensure default
values and NOT NULL can be set together. Per report from
Laurent ROCHE.
2008-03-04 DP 1.8.3 Properly quote the maintenance database name when
creating a new connection.
2008-03-04 DP 1.8.3 Show the schema correctly for EDB public synonyms that
point to other synonyms.
2008-03-04 DP 1.8.3 Remove long-dead Explain Text option from the Query Tool.
2008-03-03 DP 1.10.0 Add the ability to register external applications on
a plugins menu. Menu options can be activated based on
the current object selection, and a variety of variables
including everything needed to open a database connection
can be passed to the external utility.
2008-02-27 DP 1.10.0 Allow the user a chance to abort if there is an error
when deleting rows in the edit grid [Robins Tharakan]
2008-02-27 DP 1.10.0 Remove an obsolete FORCE option on the Maintenance
dialogue [Robins Tharakan]
2008-02-27 DP 1.8.3 Properly quote synonym names when refreshing.
2008-02-27 DP 1.10.0 Add basic support for function parameter default values
on EnterpriseDB.
2008-02-26 DP 1.8.3 Parse function parameter names correctly when they
contain commas.
2008-02-24 DP 1.8.3 FOSDEM fix: Include overriding columns in reverse
engineered SQL for child tables, rather than commenting
them out and marking as inherited.
2008-02-20 DP 1.8.3 Avoid quoting 'text' when used as a type name per Erwin.
2008-02-18 DP 1.8.3 Correctly generate table DDL when inherited columns
follow the last 'real' column, per Peter Gagarinov.
2008-02-13 DP 1.8.3 Sort the functions in the combo box on the Trigger
dialogue [Robins Tharakan]
2008-02-13 DP 1.8.3 Hide array variants of table-types in datatype selectors
where we already hide the table type itself.
2008-02-08 GL 1.8.3 Fix query that tries to apply the schema restriction.
2008-02-08 DP 1.8.3 Specify the length correctly when creating columns of
'time with time zone' and friends.
2008-02-07 GL 1.10.0 Add Drop/Reassign Owned support with a specific dialog.
2008-02-06 DP 1.10.0 Add options to the Edit Grid to allow sorting and
filtering based on the selected cell [Robins Tharakan]
2008-02-04 DP 1.8.3 Allow non-superusers to debug their own functions.
2008-02-01 GL 1.8.3 Fix query that tries to apply the DB restriction.
2008-02-01 DP 1.8.3 Ensure info passed to Guru hints is HTML-safe.
2008-02-01 HS 1.8.2 Size of the column label of SQLGrid was made variable.
2008-01-30 DP 1.8.2 Prevent a crash when viewing databases with % in the
name.
2008-01-23 DP 1.8.2 Don't try to force new databases into a specific
tablespace as this will error is non-superusers default
to pg_default.
2008-01-23 DP 1.8.2 Correct the SQL generation for EDB inline triggers.
2008-01-23 DP 1.8.2 Generate function signatures correctly if the first
parameters are OUT only.
2008-01-18 DP 1.8.2 Remove the confusing and near-useless sequence combo box
from the column dialog per discussion on support list.
2008-01-18 DP 1.8.2 Fix the WITH ADMIN membership option when creating roles.
2008-01-16 DP 1.8.2 Refresh Views correctly on EnterpriseDB.
2008-01-14 DP 1.8.2 Fix the privilege editor on the Language dialogue, per
Bborie Park.
2008-01-10 DP 1.8.2 Correctly identify the schema of trigger functions that
are in system catalogs as can be the case with integrated
full text search.
2008-01-09 HS 1.8.2 Warn the user if a file cannot be saved in the default
encoding.
2008-01-07 DP 1.8.2 Undecorated out-param types must be included in EDB-SPL
function signatures when altering comments or privileges
or dropping functions or procedures.
2008-01-07 DP 1.8.2 Ensure enums are offered as datatypes for columns.
2008-01-07 DP 1.8.2 Fix column dialogue to allow proper modification of array
columns per Erwin.
2008-01-07 DP 1.8.2 Newer build of EnterpriseDB consistently strip trailing
semi-colons from package headers and bodies. Update
reverse engineering allow for this.
2008-01-07 DP 1.8.2 Ensure the properties dialogues will work sanely with
objects named " " (!).
2008-01-07 DP 1.8.2 EDB-SPL functions require NULL to be passed in out-params
when debugging.
2008-01-07 DP 1.8.2 Ensure that EDB-SPL trigger DDL code is appropriately
formatted on newer builds of EnterpriseDB.
2008-01-03 DP 1.8.2 Ensure the password and confirmed password always match
when adding or editing roles or users.
2008-01-02 DP 1.8.1 Fix a bug that could cause a crash on GTK when closing
the query tool in certain circumstances.
2008-01-02 DP 1.8.1 Avoid a crash if the connection is lost and the Functions
node is refreshed.
2008-01-02 DP 1.8.1 Avoid crashes when working with objects with % characters
in the name.
2008-01-01 DP 1.8.1 Properly reverse-engineer the SQL for indexes with DESC,
NULLS FIRST or NULLS LAST column options.
2008-01-01 DP 1.8.1 Only offer the Jobs node if the user can access the
pgagent schema.
2007-12-19 DP 1.8.1 Ensure the 'Create Rule' context menu option is always
offered when appropriate.
2007-12-19 DP 1.8.1 Prevent the user from trying to debug catalog objects.
2007-12-17 DP 1.8.1 Refresh the tree without erroring after creating a new
package on EnterpriseDB.
2007-12-17 DP 1.8.1 Fix a crash that occured if an object called '%' was
selected in the treeview, per Alexander Steffens.
2007-12-14 DP 1.8.1 Fix a line number error in the debugger seen with
procedures which start on the same line as the 'CREATE
PROCEDURE foo IS ...' Per report from Heikki Linnakangas.
2007-12-14 GL 1.8.1 Cleanup the covering index control logic in the Foreign
Key dialogue.
2007-12-13 GL 1.8.1 Fix to refresh version string and number, and last OID,
per a report from Alexander Kirpa.
2007-12-12 DP 1.8.1 Disable CREATE FUNCTION etc. under EnterpriseDB packages
because they are created as part of the main package
body.
2007-12-12 DP 1.8.1 Fix some broken references to online help pages.
2007-12-12 DP 1.8.1 Don't offer 'Drop Cascaded' unless the user can 'Drop'
the object.
2007-12-12 DP 1.8.1 Prevent non-superusers from attempting to use the
debugger because the plugin API won't let them anyway.
2007-12-11 DP 1.8.1 Check that functions exist before debugging or setting
global breakpoints on them. Remove them from the treeview
if not.
2007-12-11 DP 1.8.1 Correct the URL for the EDB public synonym help page
2007-12-11 HS 1.10.0 Add the keyword 'WHILE' of debugger.
2007-12-10 DP 1.10.0 Add support for typmod in/out functions on custom types
[Guillaume Lelarge]
2007-12-10 DP 1.8.1 Fix the debugger's connection class to ensure database
names requiring quotes will work and that is can be used
with SSL and Kerberos connections.
2007-12-07 DP 1.8.1 Allow the length of array-typed columns to be changed
(eg. 'character varying[](100)'), per report from Ferenc
Lutischan
2007-12-05 DP 1.8.1 Don't allow the user to direct-debug trigger functions,
only global breakpoints should be used on them (or the
trigger itself).
2007-12-05 DP 1.8.1 Don't offer edbspl functions when creating triggers as
they should have inline bodies.
2007-12-04 DP 1.8.1 Don't quote database names that happen to be keywords
when starting the debugger.
2007-12-03 GL 1.10.0 Add an option to alter a language's owner
2007-11-30 DP 1.8.1 Don't offer package names and system schemas as schemas
when creating public synonyms.
2007-11-28 DP 1.8.1 Fix pgAgent's job query when a host agent is specified
so that jobs don't execute every time round the loop
regardless of schedule, per Brian Kalbfus.
2007-11-28 DP 1.8.1 Add EnterpriseDB's default database (edb) to the Server
dialog's default option.
2007-11-28 DP 1.8.1 Don't allow the user to debug an EnterpriseDB package
function or procedure if the body isn't defined.
2007-11-28 DP 1.8.1 Don't offer the user the chance to create new columns
on system catalogues.
2007-11-28 DP 1.8.1 Fix the debugger to send actual NULL values rather than
'NULL' through the EnterpriseDB callable statement API.
Allow parameter values to be NULL or empty strings on
both PostgreSQL and EnterpriseDB using the same syntax
as the Edit Grid.
2007-11-27 DP 1.8.1 Always open the PostgreSQL Help when selecting that menu
option, even if connected to EnterpriseDB.
2007-11-27 DP 1.8.1 Fix EnterpriseDB public synonym loading so that they
aren't considered system objects.
2007-11-23 DP 1.10.0 Add an option to enable/disable rules on tables [Guillaume
Lelarge]
2007-11-23 DP 1.10.0 Add options to TRUNCATE and TRUNCATE...CASCADE tables.
[Guillaume Lelarge]
2007-11-23 DP 1.8.1 Fix path discovery on Unix so standard installs can be
relocated easily.
2007-11-13 DP 1.8.1 Fix character number display in the query tool.
2007-11-07 DP 1.8.1 Use popen() when testing the versions of helper apps on
non-windows platforms to avoid an obscure bug on PPC Macs
that could leave wxExecute hanging indefinitely whilst
waiting on a zombie process.
2007-10-30 DP 1.8.1 When creating a new index and specifying both tablespace
and fill factor, make sure the SQL is formulated
correctly, per Stefan Wolf
2007-10-29 DP 1.8.1 Fix the locks tab on the server status dialogue so it
works correctly with PostgreSQL 8.3+.
2007-10-29 DP 1.8.1 Properly format the object comments shown in the
properties list when a collection node is selected. Per
report from Mike Blackwell.
2007-10-29 DP 1.8.1 Fix a bug preventing the 'on error' flag of a pgAgent job
step being edited, per Jon Roberts.
2007-10-26 DP 1.8.1 Handle the corner case when a user includes quotes in an
object name.
2007-10-26 MH 1.10.0 Add a 'Blocked By' column to the Server Status dialog
to show if a transaction is blocked by another process.
2007-10-26 DP 1.8.1 Properly escape _'s in queries for schemas, per Derek
Fonda.
2007-10-26 DP 1.8.1 Don't try to enable/disable prepared transaction related
controls on pre-8.1 servers, per Karl Zellnig
2007-10-12 DP 1.8.0 Avoid using a correlated subquery that Greenplum doesn't
support, per report from Jon Roberts.
2007-09-24 DP 1.8.0 Allow GUCs to be set on functions in PostgreSQL 8.3 and
above. [Guillaume Lelarge]
2007-09-24 DP 1.8.0 Allow GUCs to be set on users, roles and databases at
create time.
2007-09-03 DP 1.8.0 Fix the table, index and index constraint tablespace
property combo boxes to allow changes to tablespace.
2007-09-03 DP 1.8.0 Modify the object browser so that the expanded/collapsed
state of child nodes is retained when a node is
refreshed.
2007-07-19 DP 1.8.0 Refactor the Query Tool's execQuery function to prevent
pgAdmin freezing while two long running queries are
executing simultaneously.
2007-07-05 HS 1.8.0 Fixed UTF8 option was not effective by file reading and
writing of a query. and fixed crash at the time of file
save. Per report from Claudia.
2007-07-02 DP 1.8.0 Add an option to the Report Tool to open the output file
in the default browser.
2007-07-02 DP 1.8.0 Add a macro facility to the Query Tool [Krzysztof
Smigrodzki]
2007-06-25 DP 1.8.0 Add keyboard shortcuts to show and hide UI elements,
per Jan Kowalski.
2007-06-25 DP 1.8.0 Display the output pane in the query tool at query
completion if it's currently hidden, per Jan Kowalski.
2007-06-12 DP 1.8.0 Ensure files can be converted to the required encoding
before saving, per report from Christian Lins.
2007-06-12 DP 1.8.0 Warn the user and allow her to abort before re-running
a backup or restore to or from the same file, in the same
session (can occur if the first attempt returns an error
or warning). Per gripes from various users :-)
2007-06-01 DP 1.8.0 Add support for multi-parameter aggregates.
2007-05-31 DP 1.8.0 Retain column widths when refreshing the edit grid, per
Ferenc Lutischan.
2007-05-30 DP 1.8.0 Ensure logfiles and pgpass files can be correctly saved
on Windows when the username contains non-ASCII chars.
Per report from Athanasios E. Samaras.
2007-05-26 DP 1.8.0 Ensure we always allow the maximum string length possible
to be entered in the Edit Grid.
2007-05-24 GL 1.8.0 Sort servers' list alphabetically.
2007-05-18 DP 1.8.0 Fix a crash in the Edit Grid which occured if Delete was
pressed whilst editing a boolean. Per report from Erwin.
2007-05-17 DP 1.8.0 Remove bundled copies of PostgreSQL/Slony docs to make it
easier to localise the rest. Instead allow the use of
local or online copies of the PostgreSQL, EnterpriseDB or
Slony docs, each independently of the other.
2007-05-10 DP 1.8.0 Add a new command line option (-f <file>) to open an SQL
script automatically when using -q or -qc. Per request
from Taras Kopets.
2007-05-10 GL 1.8.0 Add fillfactor support on tables and indexes.
2007-05-10 DP 1.8.0 Add a new command line options (-cp <file>) to allow
direct editing of pgpass files.
2007-05-09 DP 1.8.0 Treat view columns as first class citizens. Show them on
the treeview, and allow their properties page to be
viewed. Allow editting of the default value and comment,
and reflect this in the reverse engineered SQL for the
view. Per request from Luiz.
2007-05-09 DP 1.8.0 Load second and subsequent postgresql.conf files
into the config editor correctly.
2007-05-09 DP 1.8.0 Prompt the user to save changes before opening a file
from the recent files menu on the Query Tool, per Taras
Kopets
2007-05-02 DP 1.8.0 Add auto-indent to the query tool.
2007-05-02 DP 1.8.0 Add an option to show indent guides in the query tool.
2007-05-02 DP 1.8.0 Allow spaces to be used instead of tabs in SQL editors,
and ensure the width can be set sensibly.
2007-04-30 DP 1.8.0 Allow detection and conversion of line ending format in
the query tool.
2007-04-24 DP 1.8.0 Integrate the EnterpriseDB pl/pgsql and EDB-SPL debugger
with pgAdmin [Hiroshi Saito, Dave Page]
2007-04-23 DP 1.8.0 Don't try to detect if integrated autovacuum is
running on < 8.1. Per Simon Riggs.
2007-04-04 DP 1.8.0 Display the constraint OID for index constraints, not
the index OID. Add the index OID as a new property,
per Harald.
2007-04-04 DP 1.8.0 Ensure the password change dialog works with stored
passwords.
2007-04-03 DP 1.8.0 Add support for function cost and row estimations in
PostgreSQL 8.3+.
2007-04-03 DP 1.8.0 Add support for enums in PostgreSQL 8.3+.
2007-04-03 DP 1.8.0 Copy and paste data correctly when in a cell editor in
the edit grid, per Stephan Jaensch.
2007-03-30 DP 1.8.0 Avoid creating graphical explain nodes for triggers as
they aren't part of the plan and mess up the layout.
Per report from Jeremy Drake.
2007-03-30 DP 1.8.0 Fix reverse engineering of data types with a size of 0,
such as "timestamp(0) without timezone" per Erwin.
2007-03-30 DP 1.8.0 Display the is_called sequence flag, per Erwin.
2007-03-27 DP 1.8.0 Handle resetting of sequence values more consistently,
per Erwin.
2007-03-27 DP 1.8.0 Allow editting of rows with a blank string in the primary
key in the edit grid, per Jeremy Palmer.
2007-03-16 DP 1.6.3 Fix an overflow bug in pgAgent, per report from Sabin
Coanda
2007-03-14 DP 1.8.0 Function/procedure signatures do not include OUT params.
Fix this oversight, and cleanup much of the related code.
2007-03-12 DP 1.8.0 Remove a lot debugging code of little or no use.
2007-03-12 DP 1.8.0 Position the cursor at the error position when an error
occurs in the Query Tool. Ensure the line is visible.
2007-03-12 DP 1.8.0 Use Oracle style syntax for edbspl triggers.
2007-03-12 DP 1.8.0 Show only tables & views (as 'catalog objects') in
pseudo-system catalogs such as information_schema and
EDB's sys and dbo catalogs. Lock down functionality to
prevent create/edit/drop options being offered.
2007-03-09 DP 1.8.0 Create and reverse engineer edbspl procedures using
Oracle compatible syntax.
2007-03-09 DP 1.8.0 Treat all functions & procedures as 'Functions' in
PostgreSQL, and class only EnterpriseDB edbspl functions
returning void as 'Procedures'.
2007-03-08 DP 1.8.0 Preserve column widths between queries.
2007-03-08 DP 1.8.0 Use EnterpriseDB's utilities for dump and restore EDB
databases to ensure non-PG extensions can be handled.
2007-03-07 DP 1.8.0 Speed up loading of functions and procedures by rewriting
some horribly inefficient code.
2007-03-06 DP 1.6.3 Fix a bug that prevented adding new nodes to a Slony
cluster, per Duncan Beeby.
2007-03-06 DP 1.6.3 Remember the server's SSL mode property correctly.
2007-03-05 DP 1.6.3 Prevent the RULE privilege becoming re-enabled for tables
on PostgreSQL 8.2+, per Erwin.
2007-03-05 DP 1.8.0 Add support for packages on EnterpriseDB.
2007-03-05 DP 1.6.3 Minor fix for edb/spl functions.
2007-03-02 DP 1.6.3 Fix procedure support on EnterpriseDB AS81.
2007-03-02 DP 1.8.0 Add support for public synonyms on EnterpriseDB.
2007-03-02 DP 1.8.0 Use pg_statindex (if available) to optionally display
additional index statistics on a per-table basis. Also
works for index-constraints [Guillaume Lelarge]
2007-03-01 DP 1.8.0 Display catalogs separately from schemas, and don't
treat them as system objects any longer (they can be
hidden using the display options).
2007-02-27 DP 1.8.0 Allow install time re-branding. This allows rebranded
versions of pgAdmin to be distributed without code
modifications, but with references to the original
pgAdmin being displayed instead. Also add support for
shaped splash screens.
2007-02-26 DP 1.8.0 Add a set of options to allow the user to hide selected
object types from the treeview. Note that the new default
settings will hide less commonly used objects such as
casts, languages, aggregates, operators etc.
2007-02-23 DP 1.6.3 Fix a rare bug in the Edit Grid which could cause a crash
when editting data in tables with deleted columns and a
primary key that isn;t at the beginning of the table.
Thanks to Patrick De Visschere for the test case.
2007-02-23 DP 1.6.3 Use the correct version of the Slony scripts when
creating a new cluster, per Duncan Beeby.
2007-02-22 DP 1.6.3 Prevent the Edit Grid Filter causing a crash if an
invalid filter containing a % is used, per Erwin.
2007-02-16 DP 1.8.0 Replace the Mac installer with code to create a
distribution disk image [Florian G. Pflug]
2007-02-16 DP 1.6.3 Fix a minor bug in app bundle creation for Mac [Florian
G. Pflug]
2007-02-14 DP 1.8.0 Allow entire servers to be backed up.
2007-02-14 DP 1.8.0 Allow global objects to be backed up.
2007-02-05 DP 1.8.0 Add a guru hint to warn the user of the consequences of
storing passwords, per Tony Caduto.
2007-02-05 DP 1.6.3 Fix the graphical explain to properly display backwards
index scan nodes, per Brendan O'Shea.
2007-02-05 DP 1.6.3 Fix default perspective names, per Ezequias
2007-02-05 DP 1.6.3 Monitor the streams again whilst backing up on Mac -
this no longer crashesin wx2.8. Per Dave Livesay.
2007-02-05 DP 1.6.3 Fix a crash on Mac that occurred when using some combo
boxes, per David Lowry.
2007-01-29 DP 1.6.3 Fix menu icon for Gnome [Nathan Egge]
2007-01-26 DP 1.6.3 Allow users with SUPERUSER but no other privilege flags
to create roles and databases etc. per Andy Shellam.
2007-01-23 DP 1.8.0 Browser support for Operator Families in PstgreSQL 8.3.
2007-01-22 DP 1.6.3 Handle non-default schema paths properly in the Foreign
Key dialogue, per Philipp Specht
2007-01-19 DP 1.6.3 Fix localisation of 'Tab' as a copy delimiter.
2007-01-19 DP 1.8.0 Add options to enable/disable triggers, both individually
and per-table [Guillaume Lelarge, Dave Page]
2007-01-17 DP 1.6.3 Update to support the changed syntax of pg_dump 8.2+.
2007-01-15 DP 1.6.3 Add support for Sun's compiler [Dhanaraj M]
2007-01-12 DP 1.8.0 Use pg_stattuple (if available) to optionally display
additional table statistics on a per-table basis
[Guillaume Lelarge, Dave Page]
2007-01-11 DP 1.8.0 Support for operators and op-classes in PostgreSQL 8.3.
2007-01-10 DP 1.6.3 Fix an issue in the Query Tool export option that could
result in blank lines in the export file, per Mathias
Durst and Mike.
2007-01-09 DP 1.6.3 Truncate comments containing \r\n correctly, per Erwin.
2007-01-09 DP 1.6.3 Fix query tool title which was unfortunately broken by
an earlier fix for another bug.
2007-01-04 DP 1.6.2 Enable the OK button on the database properties dialog
when variables are changed.
2007-01-04 DP 1.6.2 Refresh database objects correctly, per Guy Rouillier.
2006-12-28 DP 1.8.0 Add a 'Run Now' options for pgAgent jobs.
2006-12-28 DP 1.8.0 Retain the clipboard contents on app exit.
2006-12-28 DP 1.8.0 Add an option to show NULLs as <NULL> in the Query Tool.
2006-12-28 DP 1.8.0 Remember last used save definition filename.
2006-12-28 DP 1.8.0 Remember last used backup/restore filenames.
2006-12-28 DP 1.8.0 Refactor code to remove support for building the Query
Tool with a listview rather than a grid.
2006-12-28 DP 1.6.2 Avoid displaying multi line data in single line list
controls, per Clodoaldo Pinto Neto
2006-12-15 DP 1.6.2 Properly drop foreign keys in schemas whose names require
quoting, per M S.
2006-12-14 DP 1.6.2 Avoid a crash when closing the query tool on Solaris
[Dhanaraj M]
2006-12-07 DP 1.6.2 Display the transation start time on the server status
windows on PostgreSQL 8.3+
2006-12-07 DP 1.6.2 Reverse engineer columns with multi-word names (like
'timestamp with timezone') correctly so that precision
and array modifiers are included properly. Per Erwin.
2006-12-07 DP 1.6.2 Add '...' to truncated column comments in table SQL, per
Erwin Brandstetter.
2006-12-05 DP 1.6.2 Properly size the backup dialog, per Patrick Headley.
2006-12-05 DP 1.6.2 Ensure column headers and the insert row are shown in the
edit grid when no rows exist in the table being editted,
per Bob Pawley.
2006-12-05 DP 1.6.2 Restore dialog sizes correctly.
2006-12-04 DP 1.8.0 Refactor code to remove database base classes
2006-12-04 DP 1.8.0 Remove code specific to versions of wxWidgets that we
no longer support.
2006-12-04 DP 1.8.0 Remove obsolete support for non-Unicode builds.
2006-12-04 DP 1.6.2 Build against PostgreSQL 8.2 on Windows.
2006-12-01 DP 1.6.2 Fix some oddities in the way current per-table vacuum
settings are displayed.
2006-12-01 DP 1.6.2 Fix per-table autovacuum settings for PostgreSQL >= 8.2
per Devrim Gunduz.
2006-12-01 DP 1.6.2 Prevent the filter/sort options dialogue being opened
when data is being refreshed, per Erwin.
2006-11-29 DP 1.6.1 Prevent a crash from the query too when using File ->
Exit on GTK.
2006-11-29 DP 1.6.1 Don't paste into empty edit grids, per Howard Wang.
2006-11-29 DP 1.6.1 Guard against permission denied errors in the edit grid
per Howard Wang.
2006-11-29 DP 1.6.1 Fix some portability issues in the configure code [Max
Khon]
2006-11-28 DP 1.6.1 Properly quote function parameter names, per Ken Priest.
2006-11-28 DP 1.6.1 Don't display index constraints under the Indexes node
as well as the Contraints node, per Erwin.
2006-11-27 DP 1.6.1 Fix a minor bug in the index reverse engineering when
using non-default operator classes per Andrus.
2006-11-23 DP 1.6.1 Only enable the 'Include SQL' checkbox on the report
dialog if there is SQL to include, Per Ezequias
Rodrigues da Rocha
2006-11-21 DP 1.6.1 When checking the position & size of windows, use the
dimensions of the current display, not the primary.
2006-11-17 DP 1.6.1 Include IN/OUT/INOUT keywords in procedure identifiers
in the treeview.
2006-11-17 DP 1.6.1 Fix deletion of stored procedures, Per Erwin.
2006-11-16 DP 1.6.1 Rework the Find/Replace code to fix a couple of minor
bugs and improve readability.
2006-11-16 DP 1.6.1 Enable the OK button on the Database properties dialog
when the owner is changed, per Jim Cullison
2006-11-15 DP 1.6.1 Prevent a crash if the 'View Filtered Data' filter dialog
is cancelled. Per Erwin Brandstetter
2006-11-06 DP 1.6.0 Hide binary data (bytea) in the edit grid.
2006-10-12 DP 1.6.0 Add an installer for Mac.
2006-10-03 HS 1.6.0 Fixed display of pg_dump/pg_restore output in non-ASCII
charactersets.
2006-09-28 DP 1.6.0 Ensure the schema is specified when backing up individual
tables [Luca Arzeni]
2006-09-15 DP 1.6.0 When exporting data to the local charset wxFile::Write
will crash if it can't convert the data. Check that
conversion is possible before writing each row and skip
if not. If any failures have occured, tell the user how
many, and suggest they use UTF8 instead. Per Harald
Armin Massa
2006-09-11 DP 1.6.0 Add support for building indexes concurrently on 8.2.
2006-09-08 DP 1.6.0 Use SQL standard type names where appropriate. Show
them as 'aliases' in the browser. [Magnus Hagander/
Dave Page]
2006-09-06 DP 1.6.0 The RULE privilege is not applicable to tables in 8.2
so don't use it.
2006-09-01 DP 1.6.0 Add support for building Mac Universal Binaries.
With help from Florian G. Pflug and Chris Campbell.
2006-08-30 DP 1.6.0 Fix maintenance dialogue for Primary Keys and Unique
constraints per Alexander Kirpa
2006-08-30 DP 1.6.0 Favour a primary key over an OID column when updating
data in the edit grid to benefit from the index, per
Vivek Khera.
2006-08-30 DP 1.6.0 Require the use of wxWidgets 2.7 or above (needed for the
wxAUI classes.
2006-08-30 DP 1.6.0 Use the wxAUI library to provide dockable window elements
on the main window, query tool and edit grid, giving
us a much more modern look and feel.
2006-08-30 MH 1.6.0 Allow for -q to open query tool without opening
main window. Add -qc switch to open query tool and
autoconnect using a connection string.
2006-08-30 MH 1.6.0 Disable splash-screen completely in debug builds.
2006-08-29 MH 1.6.0 Add a New Window menu/toolbar to the query tool.
2006-08-15 DP 1.6.0 Set focus on the filter textbox when opening the View
data filter options [Guillaume Lelarge]
2006-08-15 DP 1.6.0 Auto-select the next item when removing columns from
the View Data sort options dialog [Guillaume Lelarge]
2006-07-21 DP 1.6.0 Fix custom vacuum settings editting, per Benjamin
Krajmalnik
2006-07-18 DP 1.4.3 Display job steps and schedules properly in the Job
dialogue, per Eric Shuman.
2006-07-17 DP 1.4.3 Display interval precision properly, per Walter Haslbeck
2006-07-04 DP 1.6.0 Make elements of the main windows dockable for
maximum configurability.
2006-07-04 DP 1.6.0 Add 'scratch pads' to the Edit Grid and Query Tool
windows to use when copying and pasting data back
and forth.
2006-07-04 DP 1.6.0 Add a proper menu to the Edit Grid window.
2006-06-30 DP 1.4.3 Return the script return value when executing shell
scripts from pgAgent, per Eric Shuman
2006-06-22 DP 1.4.3 Use a slider instead of a spin control to avoid a
wxGTK bug on the status form, per Peter Eisentraut.
2006-06-15 DP 1.6.0 Add a new Find & Replace dialogue to the query tool,
implementing all the normal Find & Replace options as
well as a powerful regular expression search mode.
2006-06-15 DP 1.6.0 Add a pgAgent option to log to a file on *nix [Jeremy
Palmer]
2006-06-14 DP 1.6.0 Add a Redhat init script for pgAgent [Jeremy Palmer]
2006-06-13 DP 1.6.0 Display non-default op classes in index definitions.
2006-06-12 DP 1.6.0 Minor fixes to the browser code to properly add new nodes
2006-06-12 DP 1.6.0 Fix creation of jobs with multiple steps or schedules per
Jeremy Palmer
2006-06-12 DP 1.6.0 Remove unused fc1 packaging files
2006-05-31 DP 1.6.0 Retain values in the edit grid following a failed
insert or update per Mario Splivalo. Don't silently lose
changes if the user refreshes the data or closes the
window.
2006-05-30 DP 1.6.0 Display, and allow null values to be set in boolean
columns in the Edit Grid per Hubert Plaschke.
2006-05-26 DP 1.6.0 Add a data dictionary report for tables.
2006-05-24 DP 1.6.0 Don't enable the OK button on the Grant Wizard until
there is something to do, per Dave Minter.
2006-05-24 DP 1.6.0 Use PQresultErrorField() to get more error details
from query results. Requires libpq 7.4+.
2006-05-23 DP 1.6.0 Highlight the error word in the query tool if a syntax
error is reported by the database.
2006-05-23 DP 1.6.0 Add a guru hint to advise users to use the CREATE script
tool to edit function/view code in the Query Tool.
2006-05-22 DP 1.6.0 Display the current character number in the query tool
status bar.
2006-05-22 DP 1.4.3 Allow non-superusers to edit roles where appropriate
[Thomas Sondag]
2006-05-22 DP 1.6.0 Add options to show line ends and whitespaces in the
query tool.
2006-05-17 DP 1.4.3 Allow non-superuser roles with the appropriate
permissions to create roles and DBs.
2006-05-15 DP 1.4.3 Fix a bug in the pgpass save code that could
damage files.
2006-05-15 DP 1.6.0 Add a word wrap option to the query tool editor.
2006-05-15 DP 1.6.0 Add brace highlighting to the SQL Text Box control.
2006-05-15 DP 1.6.0 Don't save the position/size when closing minimised
Windows as the size values will be wrong on some OSs.
2006-05-15 DP 1.6.0 Add a Copy menu option to the main form to copy from the
SQL pane.
2006-05-15 DP 1.6.0 Detect and warn the user of concurrent edits of
functions, views and job steps.
2006-05-12 DP 1.6.0 Allow the user to choose whether or not to restore the
environment when reconnecting to a particular server.
2006-05-10 DP 1.6.0 Allow pasting of entire rows in the View Data tool
[Edward Di Geronimo Jr]
2006-05-10 DP 1.6.0 Use escape string syntax (E'foo') where required.
2006-05-09 DP 1.6.0 Update the Windows build environment for VC++ 8.0 (now
free from http://msdn.microsoft.com/vstudio/express/)
2006-05-05 DP 1.6.0 Add an internal XML reporting API, HTML XSL stylesheet
with XSLT processing capabilities and selection of
schema/object/data reports.
2006-05-03 DP 1.6.0 Add support for PostgreSQL 8.2's CONNECT privilege on
databases, and USAGE on sequences (which also have a
reduced set of privileges now).
2006-05-03 DP 1.4.3 Use the correct encoding in the View Data filter options
per Ferenc.
2006-04-30 DP 1.6.0 Pre-encrypt passwords before sending them down the wire,
or displaying them in SQL statements.
2006-04-30 AP 1.6.0 Fix Explain issue with multiple lines [Miha Radej]
2006-04-30 AP 1.6.0 Scripting for view SELECT/INSERT/UPDATE
2006-04-30 AP 1.6.0 Scripting for table SELECT/INSERT/UPDATE
2006-04-30 AP 1.6.0 cleanup submenu handling to avoid touching events.cpp
when menus are added
2006-04-30 AP 1.6.0 Use virtual ListView for Query Tool, so no more retrieval
time
2006-04-28 DP 1.4.3 Ensure the user is warned if files cannot be written.
2006-04-27 DP 1.6.0 Add an accelerator key (Delete) for deleting rows in the
edit grid, per Emil Nowak.
2006-04-21 DP 1.6.0 (pgAgent) Replace the batch job execution code for
Windows with a custom popen equivalent based on
CreateProcess(). This is needed on Win2K on which
_popen() will not work from a service.
2006-04-12 DP 1.6.0 Allow the tab character to be used as the clipboard
column separator to allow pasting of query results
straight into apps like Excel, or OOo Calc [Edward Di
Geronimo Jr.]
2006-04-06 DP 1.6.0 Add a --disable-docs configure option to prevent the
installation of docs [Miha Radej]
2006-03-20 DP 1.6.0 Refactor Edit Grid and Query Grid into one common base
class for the control. Use the in-built wxTable for
further a performance boost [Edward Di Geronimo Jr.]
2006-03-20 DP 1.4.3 Install PkgInfo into the Contents directory in the OSX
appbundle, per John DeSoi.
2006-03-20 DP 1.4.3 Detect and correctly use GNU vs. BSD xargs when
completing an appbundle install, per John DeSoi.
2006-02-27 DP 1.6.0 Don't double-link to libssl/libcrypto [Loic Minier]
2006-02-27 DP 1.6.0 Enhance the query tool to allow copy/paste of arbitrary
groups of columns, rows or individual cells.
[Edward Di Geronimo Jr]
2006-02-27 DP 1.6.0 Change '<localpipe>' to 'local socket' [Peter Eisentraut]
2006-02-22 DP 1.6.0 Tidy up dlgServer, per Peter Eisentraut.
2006-02-22 DP 1.6.0 Split src/Makefile.am into one fragment per sub directory
for ease of maintenance.
2006-02-22 DP 1.6.0 Allow the admin modules to be built with PGXS if required
[August Zajonc]
2006-02-21 MH 1.6.0 Reject invalid command line options in pgAgent
2006-02-21 MH 1.6.0 Minimal linking for pgAgent under *nix
2006-02-21 DP 1.4.2 Fix a typo in the admin pack README [August Zajonc]
2006-02-19 AP 1.4.2 Fix serial column detection for 8.1 per Kris Jurka
2006-02-19 AP 1.6.0 Display column dependencies
2006-02-19 AP 1.6.0 Rearrange "view data" position in toolbar/menu
2006-02-17 DP 1.4.2 Mask the password when logging the connection string.
2006-02-17 DP 1.4.2 Properly escape single quotes in connection strings.
2006-02-08 DP 1.4.2 Re-arrange the Win32 dependencies so that iconv, libxml2
and wxwidgets are located in $PGADIR/../pgadmin3-deps/
2006-02-08 MH 1.6.0 Add a 'Favourites' query organiser to the Query Tool.
Note; this adds a dependecy on libxml2 (and iconv).
2006-02-06 DP 1.4.2 Properly enable the redo button in the Query Tool when
appropriate, per PromoTrade
2006-02-06 DP 1.6.0 Allow selection and copy of subsets of the columns and
rows in the Edit Grid [Edward Di Geronimo Jr]
2006-02-06 DP 1.6.0 Cleanup if the query tool leaves a transaction in an
error state when the query ends.
2006-01-30 AP 1.6.0 Fix inherited columns (don't create/edit them) per Peter
Eisentraut.
2006-01-30 MH 1.6.0 Add autocompletion to the Query Tool, based on the logic
used by psql. Triggered with Control+Space, and
optionally the Tab key as well.
2006-01-30 DP 1.4.2 Add missing files to the Unix tarball, per Andrus
xtra/wxbuild/*, src/utils/precomp.cpp,
src/main/pgAdmin3.rc
2006-01-27 DP 1.6.0 Allow the number of rows shown in the Edit Grid to be
limited and add a 'View top 100 rows' option to the
table/view context menus. [Magnus Hagander, Dave Page]
2006-01-25 DP 1.6.0 Prevent deletion of the blank item in config editors, and
ensure undo will only work on the appropriate line.
2006-01-25 MH 1.6.0 Add a password file editor,
2006-01-23 MH 1.4.2 Read config files in the local encoding scheme
2006-01-22 DP 1.6.0 Rename text docs to match GNUish standards, remove all
HTML markup and wrap at col 80.
2006-01-19 DP 1.6.0 Fix capitalisation of menu items. Add '...' to the end of
items that open dialogues [Peter Eisentraut]
2006-01-19 MH 1.6.0 Display the client start time on the status dialogue with
PostgreSQL 8.1+
2006-01-17 DP 1.6.0 Allow set returning functions to be created.
2006-01-17 DP 1.4.2 Display the definition of set returning procedures
correctly.
2006-01-17 DP 1.4.2 Fix drop procedure by including IN/OUT parameter flags in
the name.
2006-01-13 DP 1.4.2 Fix role SQL - correctly define CREATEROLE/NOCREATEROLE
per Andrus.
2006-01-11 MH 1.6.0 Allow result copy quoting configuration to be set
explicitly rather than using the result export settings
2006-01-09 MH 1.6.0 Add -a and -q command line options to auto connect to a
server and open a query window respectively
2006-01-09 MH 1.4.2 Honour the copy quoting setting properly in the SQL
results pane
2006-01-09 MH 1.6.0 Use Ctrl-A to select all results in the query results
pane.
2006-01-09 MH 1.4.2 Set the initial Unicode/Local charset options correctly
in the Export dialogue
2005-12-26 AP 1.4.2 Fix PK detection in EditGrid per Andrus Moor
2005-12-26 AP 1.4.2 Fix Bitmap Index explain per Alexander Kirpa
2005-12-23 DP 1.4.2 Use ELSIF not ELSEIF in pgagent.sql for compatibility
with 7.x servers [Glen Sasek]
2005-12-22 HS 1.6.0 dlgLanguage name+comment, dlgDatabase comment
2005-12-15 DP 1.4.2 Exclude system schemas by name rather than OID, so that
'public' can be safely renamed.
2005-12-12 AP 1.4.2 fix slony node statistics
2005-12-11 AP 1.6.0 support 8.1 language templates
2005-12-11 AP 1.4.2 Fix: Unsubscribe set on receiver
2005-12-11 AP 1.4.2 Another wxComboBox(2.6.2) related fix
2005-12-09 DP 1.4.1 Default the encoding of new databases to the cluster
encoding, per Peter Eisentraut.
2005-12-09 DP 1.4.1 Sort encoding names in dlgDatabase, per Peter Eisentraut.
2005-12-06 AP 1.4.1 store UTF8 connect info in pgpass.conf if necessary
2005-12-03 AP 1.4.1 Major fix for wx2.6.2 API changes (comboboxes)
2005-12-02 DP 1.4.1 Drop constraints on columns before the columns themselves
[Miha Radej]
2005-12-01 AP 1.4.1 Deal with incompatible wx2.6.2 API changes (comboboxes)
2005-11-30 AP 1.4.1 Graphical explain: distinct scan images
2005-11-25 DP 1.4.1 Fix the server status SQL query
2005-11-25 FGP 1.4.1 Don't include pgAgent in the Mac OSX bundle
2005-11-25 FGP 1.4.1 Include pg_dump/pg_restore in the Mac OSX bundle
2005-11-20 DP 1.4.1 Use a proper 'Save As' style dialogue for selecting
backup files
2005-11-20 AP 1.4.1 Don't show pk hint when editing view
2005-11-20 AP 1.4.1 Add missing NO ACTION FK constraint
2005-11-11 DP 1.6.0 Set version numbers whereever required from version.h
during bootstrap
2005-11-11 AP 1.6.0 leave pre-1.5 server config settings untouched
2005-11-10 AP 1.6.0 Configurable indent in ctlSqlBox
2005-11-10 DP 1.6.0 Ensure we always use aclocal/automake 1.9 during bootstrap
2005-11-10 AP 1.4.1 Fix role rename per Antonio
2005-11-09 AP 1.6.0 database and schema display restriction
2005-11-09 AP 1.6.0 overhaul of server config settings
2005-11-09 AP 1.4.1 fix procedure/triggerFunc collection list
2005-11-09 AP 1.4.1 Allow all 8.x column changes per Chris Velevitch
2005-11-09 AP 1.4.1 Fix param name quoting for procedures per Alex Tyagloff
2005-11-10 DP 1.6.0 Overhaul the autoconf stuff. Make full use of
pg_config/wx-config.
2005-11-04 AP 1.4.0 Fix SET role per Florian Pflug, fix role help
2005-11-04 DP 1.4.0 Fix role inheritance option when creating roles, per Mike
Allen
2005-11-03 DP 1.4.0 Minor fix to the pgAgent command line parser, per Harald
Armin Massa