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
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445
|
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-07-06 GL 1.10.4 Fix an escaping issue in the connection handling. Patch
from Benedek Laszlo.
2010-06-10 GL 1.10.4 Fix quoting of TABLE parameters in a function. Fix
also the quoting of the PL.
2010-06-08 AV 1.10.4 Ensure the variable editor is setup correctly upon
dialog creation.
2010-06-08 AV 1.10.4 Avoid a bug in the package dialog which could prevent
a comment being editted.
2010-06-08 AV 1.10.4 Don't pass values to OUT parameters when invoking
pl/pgsql functions in the debugger.
2010-06-02 GL 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
2005-11-03 DP 1.4.0 Honour type length/precision when creating composite types
per Ivan
2005-11-02 AP 1.4.0 Fix crash in trigger property per Oriza Triznyak
2005-11-01 AP 1.4.0 Fix function return type array per Andras Voros
2005-11-01 AP 1.4.0 Fix query tool connect annoyance per Florian Pflug
2005-10-31 DP 1.4.0 Fix eventlog output in pgAgent, per Paolo Saudin
2005-10-31 DP 1.4.0 Quote member names in compsoite types, per Ivan
2005-10-31 DP 1.4.0 Enable the precision textbox when adding numeric members
to composite types, per Ivan
2005-10-30 DP 1.4.0 Display line numbers in the query tool to aid function
debugging/editting
2005-10-30 DP 1.4.0 Don't enable the OK button when setting the ACL for
as-yet-uncreated objects
2005-10-27 DP 1.4.0 Reverse dialog OK/Cancel buttons for UI consistency on
OS X per John DeSoi
2005-10-27 DP 1.4.0 Append the .sql file extension when saving files as type
sql on OS X, per Florian G. Pflug
2005-10-24 DP 1.4.0 Prevent attempts to backup or restore if pg_dump or
pg_restore cannot be found.
2005-10-23 AP 1.4.0 Fix crash when extracting schema from slony cluster
2005-10-22 AP 1.4.0 Fix New.. context menu
2005-10-21 AP 1.4.0 Fix Create a.. toolbar button on collection per Li Fei
2005-10-20 AP 1.4.0 Fix Maintenance crash of disconnected DBs per
A.J.Langereis
2005-10-20 AP 1.4.0 Fix Unicode/pgsql80win32 hint per Oryza Triznyak
2005-10-20 DP 1.4.0 Ensure the user can cancel the maintenance dialogue when
it is running.
2005-10-20 DP 1.4.0 Fix the recent files list on the config file editor. per
Miha Radej
2005-10-18 DP 1.4.0 Correct font size on Splash and About forms on Mac.
2005-10-18 AP 1.4.0 Prevent refresh of the servers treeview node
2005-10-18 DP 1.4.0 Fix the autoconf code to ensure the debug and static
options do what they should, and that a unicode wx build
is used
2005-10-18 DP 1.4.0 Ensure strings can be editted in the data grid on Mac.
2005-10-14 DP 1.4.0 Prevent errors in the logger causing crashes
2005-10-14 DP 1.4.0 Use a sensible default location for the logfile
2005-10-12 AP 1.4.0 Fix 'ambiguous proname column' bug for servers < 8.0
2005-10-12 AP 1.4.0 Fix count crash on tables per Merlin Moncure
2005-10-12 AP 1.4.0 Fix slony detection on tables for pgsql7.x
2005-10-08 AP 1.4.0 Fix "New" context menu crash on disconnected server per
Tomasz Rybak
2005-10-08 AP 1.4.0 Check for catalog access privilege in pg_authid and
pg_depend per Christopher St.John
2005-10-04 AP 1.4.0 -t cmd line option to enable language debugging
2005-10-03 AP 1.4.0 pg_autovacuum support
2005-10-03 AP 1.4.0 upgrade slony node
2005-09-17 AP 1.4.0 Allow Query Tool to use multiple connections
2005-09-04 AP 1.4.0 use ddlscript to replicate schema changes
2005-09-04 AP 1.4.0 table reverse engineering sql changes
2005-09-04 AP 1.4.0 role fixes
2005-09-04 AP 1.4.0 more guru hints
2005-09-03 DP 1.4.0 new splash screen
2005-08-23 AP 1.4.0 shared dependencies
2005-08-21 AP 1.4.0 Roles
2005-08-21 AP 1.4.0 smaller icons for win32
2005-08-11 DP 1.4.0 New set of icons, custom designed by Niko [ennixo at
free.fr]
2005-08-11 AP 1.4.0 pgServerObjCollection per Eugene Shekhtman
2005-08-08 AP 1.4.0 Refactoring object and tool handling using class factories
to make extensions easier
2005-08-02 AP 1.4.0 Support for pgsql 8.1 prepared transactions
2005-08-01 AP 1.4.0 Store passwords in .pgpass/pgpass.conf
2005-08-01 AP 1.4.0 Allow server registration without connect
2005-07-21 DP 1.4.0 Prompt the user before removing columns, constraints or
inherited tables in the table dialogue.
2005-07-06 DP 1.4.0 Prompt the user to cancel running queries before closing
the Query tool.
2005-07-04 DP 1.4.0 Check for and display asynchronous notifications in the
query tool.
2005-06-21 AP 1.4.0 typo fixes, rename "initial db" to "maintenance db"
2005-06-19 AP 1.4.0 pgAgent moved under server, some more fixes
2005-06-19 AP 1.4.0 further translation issues
2005-06-17 AP 1.4.0 reduce translation nightmare
2005-06-17 AP 1.4.0 use wxDatePickCtrl for wxCalendarBox
2005-06-17 AP 1.2.3 Fix changing initial db
2005-06-09 DP 1.4.0 Flash the task bar icon at the user if a query finishes
and the query window is not active.
2005-06-09 AP 1.4.0 Different icons for own and foreign slony sets and
subscriptions
2005-06-09 DP 1.2.3 Fix disable triggers option for data only plain text
backups per Howard Cole.
2005-06-03 AP 1.4.0 Support for pgsql 8.1 aggregate sortop
2005-06-03 AP 1.4.0 Support for pgsql 8.1 pg_stat_activity
2005-06-03 AP 1.4.0 Support for pgsql 8.1 instrumentation
2005-06-01 AP 1.4.0 Support for Procedures aka functions "with out-parameters"
2005-06-01 AP 1.4.0 Support for EDB8.0
2005-05-31 DP 1.2.3 Fix domain RE SQL, per Ivan
2005-05-31 DP 1.2.3 Add missing ; to RE SQL, per Ivan
2005-05-27 DP 1.4.0 New WiX based installer for Win32
2005-05-25 DP 1.4.0 Cleanup doc location code for internal consistency
2005-05-25 DP 1.4.0 Reorganise doc index, cleanup inappropriate/old docs and
improve admin pack documentation
2005-05-24 DP 1.4.0 Add pgAgent service/daemon, pgAdmin control interface and
documentation
2005-05-10 HS 1.2.2 Display comments on contraints properly
2005-05-08 DP 1.4.0 Major source code reshuffle
2005-05-08 DP 1.4.0 Overhaul *nix automake build system
2005-03-25 DP 1.4.0 Mac OSX support [Florian G. Pflug]
2005-04-22 AP 1.4.0 more Hint enhancements
2005-04-19 AP 1.4.0 Hint enhancements
2005-04-18 AP 1.4.0 Unix Domain Socket additional stuff
2005-04-18 AP 1.4.0 switch to wxWidgets 2.6
2005-04-15 DP 1.4.0 Unix Domain Socket support as inspired by Dominique
Quatravaux
2005-04-07 AP 1.4.0 VACUUM hint
2005-04-04 AP 1.4.0 Control dependent win32 services
2005-04-01 AP 1.4.0 Speed up of column property retrieval
2005-04-01 DP 1.2.2 Fix changing of view ownership
2005-03-28 AP 1.4.0 FK MATCH FULL
2005-03-28 AP 1.4.0 Option: User defined system schemas
2005-03-27 AP 1.4.0 Guru hint for server connections
2005-03-25 DP 1.2.1 Correctly identify primary key columns in properties pane.
2005-03-18 DP 1.2.1 Set column stats and comments correctly when creating
tables.
2005-03-18 DP 1.2.1 Include the hostname in the connect string for Kerberos
support, per Magnus Hagander
2005-03-15 FGP 1.4.0 Fix for non-SSL enabled libpq builds
2005-03-15 HS 1.4.0 Mask the password on the main tab of the user properties
dialogue
2005-03-13 AP 1.4.0 Change plain backup file default extension to .sql
2005-03-13 AP 1.4.0 Add CASCADE dropping
2005-03-04 DP 1.2.1 Fix aggregate SQL generation per James Prichard
2005-03-03 AP 1.4.0 graphical EXPLAIN
2005-03-03 AP 1.4.0 pgAgent fixes (jobId)
2005-03-02 DP 1.4.0 Rewrite pgAgent browser code to use pgCollection
2005-02-25 AP 1.4.0 some more Slony-I stuff
2005-02-24 AP 1.4.0 some Slony-I stuff
2005-02-24 AP 1.2.1 require unicode to compile utffile.cpp
2005-02-23 AP 1.4.0 Slony-1 statistics
2005-02-14 AP 1.2.1 TreeSelChange fixes (menu/statistics/dependency refresh)
2005-02-14 AP 1.4.0 wx2.5.4 preparation
2005-02-13 AP 1.4.0 Slony admin node, join cluster using pg_dump
2005-02-13 AP 1.2.1 Make sure IsAlive check isn't affected by dead
transactions
2005-02-13 AP 1.2.1 Fix missing schema prefix for casts
2005-02-11 AP 1.4.0 Slony-I support
2005-02-09 AP 1.2.1 fix trigger reengineering name quoting per Lucas Galfaso
2005-02-07 AP 1.2.1 remove tablespace for sequences
2005-02-07 AHP 1.2.1 fix libpq/ssl library detection
2005-01-14 AP 1.2.1 table statistics including TOAST and indexes
2005-01-14 AP 1.2.1 fix adding sequence columns
2005-01-14 AP 1.2.1 fix Grant Wizard for functions per Robert Köpferl
2005-01-14 AP 1.2.1 fix reengineered DOMAIN with CHECK per Robert Köpferl
2005-01-13 DP 1.2.1 fix EXPLICIT CAST sql generation per Merlin Moncure
2005-01-07 AP 1.2.1 fix closing QueryTool if FindDlg still open per
Maximiliano Di Rienzo
2005-01-07 AP 1.2.1 fix quoting identifiers starting with numbers per
Alexander Borkowski
2005-01-04 AP 1.2.1 fix typo in pgDomain per Pascal Pochet
2004-12-16 AP 1.2.1 fix server menu after failed connect
2004-12-15 AP 1.4.0 Fix changing pg_hba.conf
2004-12-10 AP 1.2.1 Fix missing drop confirmation per Cheetah
2004-12-06 AP 1.2.1 Fix tablespace reference in namespace
2004-11-19 AP 1.2.0 catch possible false error msg
2004-11-19 AP 1.2.0 fix tables statistics
2004-11-18 AP 1.2.0 fix change column dialog per Walter Haslbeck
2004-11-18 AP 1.2.0 fix missing schema in EditGrid per Martin Susil
2004-11-16 AP 1.2.0 fix pg_dump option
2004-11-10 AP 1.2.0 Remove tablespace from schema (pgsql post-beta4 change)
2004-11-10 AP 1.2.0 Fix properties for multiply inherited tables per Riccardo
G. Facchini
2004-11-10 AP 1.2.0 Fix OSX issue per Patrick Hatcher
2004-11-09 AP 1.2.0 Fix remembering SSL connection parameter per Justin Clift
2004-11-09 AP 1.2.0 Fix GTK comboboxes per Tim Booth
2004-11-05 AP 1.2.0 Disable changing parameters of connected servers
2004-11-04 AP 1.2.0 Fix duplicate functions in Cast dialog per Alexander
Borkowski
2004-11-03 AP 1.2.0 MSW Combobox Workaround: missing EVT_TEXT events
2004-11-02 AP 1.2.0 Fix some type related issues per Alexander Borkowski
2004-11-02 AP 1.2.0 Fix some owner change related issues per Alexander
Borkowski
2004-10-29 AP 1.2.0 full casting in utffile fixing some compilers
2004-10-27 AP 1.2.0 Workaround for wxGrid bug not returning selected rows
2004-10-27 AP 1.2.0 Fix user/group selection in privileges per Walter
Haslbeck, Gary Doades
2004-10-27 AP 1.2.0 Fix refresh when dropping single object from collection
listview
2004-10-26 AP 1.2.0 fix $$ translation problem per Miha Radej
2004-10-22 AP 1.2.0 fix Edit Tool to store data when selecting a row per
Virgil Frum
2004-10-22 AP 1.2.0 fix Query Tool which marked text as changed when scrolling
per Gary Doades
2004-10-22 AP 1.2.0 Workaround for wxMSW-2.5.3 malfunctioning combobox per
Gary Doades
2004-10-22 AP 1.2.0 fix Query Tool recent menu per Gary Doades
2004-10-22 AP 1.2.0 fix column type change sql per Ben Trewern
2004-10-21 AP 1.2.0 fix SET DEFAULT FK restriction per Ferenc from Hungary
2004-10-21 AP 1.2.0 refresh fixes when modifying object from collection list
2004-10-21 AP 1.2.0 sequence fixes
2004-10-16 AP 1.2.0 use wxWidgets 2.5.3
2004-10-15 AP 1.2.0 change unsigned conversion for oids per Richard van den
Berg, Patrick Hatcher
2004-10-14 AP 1.2.0 Prevent StatusBar from being overwritten by Toolbar per
Virgil Frum
2004-10-13 AP 1.2.0 Connect to databases with special names per Frank Lupo
2004-10-08 AP 1.2.0 review object owner code regarding pgsql versions
2004-10-08 AP 1.2.0 remove maximize button on MSW
2004-10-07 AP 1.2.0 Fix new server ssl option duplication on connect failure
per Alexander Borkowski
2004-10-06 AP 1.2.0 Fix cast property crash per Alexander Borkowski
2004-10-05 AP 1.2.0 Use PostgreSQL's list of keywords for syntax highlighting
2004-10-05 AP 1.2.0 Fix adding columns with constraints using table properties
on 7.3 and 7.4 per teknokrat, Virgil Frum
2004-10-05 DP 1.2.0 Drop rows correctly when selected in reverse in the edit
grid. Also, confirm drop first. per Virgil Frum
2004-09-27 DP 1.2.0 Dynamically link libpq/OpenSSL for sensible installation
with Win32 PostgreSQL
2004-09-18 DP 1.2.0 Prevent dropped servers reappearing after View System
Objects change.
2004-09-17 AP 1.2.0 GRANT for functions in reengineered SQL window
2004-09-17 AP 1.2.0 Fix Database creation for 7.3/7.4 per Jona
2004-09-16 AP 1.2.0 resources: use wxID_xxx IDs to enable GTK wxStockButtons
2004-09-16 AP 1.2.0 resources: use 12d height for comboboxes (GTK positioning
issue)
2004-09-16 AP 1.2.0 rewrite of properties actions
2004-09-16 DP 1.2.0 mask passwords on dlgServer [Ivan Nejgebauer]
2004-09-15 DP 1.2.0 fix function return type quoting
2004-09-10 AP 1.2.0 fix GrantWizard for sequence and view
2004-09-10 AP 1.2.0 fix type quoting
2004-09-08 AP 1.2.0 fix OnAdd server property positioning
2004-09-05 AP 1.2.0 performance speedup retrieving server features
2004-09-05 AP 1.2.0 qtIdent checks keywords
2004-08-29 AP 1.2.0 Sequence schema fix
2004-08-25 DAP 1.2.0 Prevent crash when non-superuser views database
properties.
2004-08-18 AP 1.2.0 set PGPASSWORD environment for backup/restore
2004-08-18 AP 1.2.0 fix ACL for quoted user/group names
2004-08-15 AP 1.2.0 buglet cleanups
2004-08-11 AP 1.2.0 restore wizard
2004-08-11 AP 1.2.0 rework of ctlComboBox
2004-08-09 AP 1.2.0 server property
2004-08-05 AP 1.2.0 win32 service control
2004-08-05 AP 1.2.0 refactor tree context menu: create instead of en/disable
items
2004-08-02 DP 1.2.0 Auto-discover locally installed servers when registered by
the Win32 binary installer.
2004-07-30 AP 1.2.0 Tablespace usage fix for objects using the database's
default tablespace
2004-07-27 AP 1.2.0 Reworked schema prefixing
2004-07-25 AP 1.2.0 support of pg_xxx_size if available
2004-07-21 AP 1.2.0 Improved disconnect handling
2004-07-21 AP 1.2.0 StatusBar with size handle for frmStatus, dlgFunction and
dlgView
2004-07-21 AP 1.2.0 Update ServerStatus to pg_logdir_ls
2004-07-21 AP 1.2.0 catch SIGPIPE
2004-07-20 AP 1.2.0 owner, name, comment refactoring in dlgProperty
2004-07-20 AP 1.2.0 support of function parameters
2004-07-20 AP 1.2.0 tablespace changes
2004-07-19 AP 1.2.0 fix dependency display for tablespaces and users
2004-07-18 AP 1.2.0 Update ServerStatus to pg_logfiles_ls and
pg_file_read/pg_file_length
2004-07-18 AP 1.2.0 Allow change of some function attributes
2004-07-12 AP 1.2.0 Fix check constraint in table reengineering
2004-07-11 AP 1.2.0 Fix combobox size/position issue on gtk
2004-07-11 AP 1.2.0 Fix button height issue with modern gtk themes
2004-06-30 AP 1.2.0 Tablespace ACLs
2004-06-23 DP 1.2.0 Split Windows installer into a merge module and installer
to allow inclusion in other packages.
2004-06-23 DP 1.2.0 Allow cancelling of queries and termination of backends
from server status dialogue for 8.0+.
2004-06-20 AP 1.2.0 backup database using pg_dump
2004-06-19 AP 1.2.0 Tablespace dependencies
2004-06-19 AP 1.2.0 combobox guessing cleanups
2004-06-18 AP 1.2.0 8.0 Tablespace
2004-06-18 AP 1.2.0 Count menu instead of refresh to count rows in a table
2004-06-18 AP 1.2.0 CLUSTERed index support for PostgreSQL 7.4 - ALTER TABLE
foo CLUSTER ON blah;
2004-06-17 AP 1.2.0 copy rows to clipboard from Query Tool and View Data Tool
2004-06-16 AP 1.2.0 allow omitting server disconnect when switching "Show
System Objects"
2004-06-16 AP 1.2.0 guess combobox selection while typing
2004-06-13 AP 1.2.0 fix "no schema" bug when database is initial database
2004-06-11 AP 1.2.0 Apply for some function and view property dialogs
2004-06-11 AP 1.2.0 Display server log
2004-06-08 AP 1.2.0 Allow Server Status & Maintenance windows to be resized
to allow easy reading of data
2004-06-07 AP 1.2.0 changed connection loss handling
2004-06-07 AP 1.2.0 fix storing of existing files (didn't truncate)
2004-06-06 AP 1.2.0 GRANT wizard
2004-06-06 AP 1.2.0 ALTER AGGREGATE/FUNCTION/GROUP/LANGUAGE/SCHEMA/TRIGGER
/USER RENAME TO for 7.4+
2004-06-04 AP 1.2.0 SQL Window: Try to preserve result column width
2004-06-04 AP 1.2.0 8.0 support: comment on cast/conversion/language
2004-06-04 AP 1.2.0 checks on column type changes
2004-05-28 AP 1.2.0 handle lost connections safely
2004-05-28 AP 1.2.0 fix server status not cleaning old connections
2004-05-28 AP 1.2.0 line numbers in function definition property dialog
2004-05-26 AP 1.2.0 warn when deleting superuser privilege
2004-05-10 DP 1.2.0 Generate function SQL correctly when the return type needs
a schema specification
2004-05-04 DP 1.2.0 Prevent duplication of functional indexes
2004-03-30 AP 1.2.0 no initial language selection (using system default)
2004-03-25 AP 1.2.0 Allow initial selection of language "Default"
2004-03-24 AP 1.2.0 changed font handling to accept exotic weights
2004-03-17 AP 1.2.0 Updated sources for wx 2.5.1
2004-03-17 AP 1.2.0 Added Font Option
2004-03-06 AP 1.2.0 Fixed missing qtIdent for CREATE DATABASE TEMPLATE option
2004-02-23 DP 1.2.0 Correct syntax for constraint comments generated SQL
2004-01-30 DP 1.2.0 Include column comments in generated table SQL
2004-01-13 AP 1.2.0 Fix crash refreshing dropped object
2003-12-28 AP 1.2.0 gtk: fix for dlgForeignKey combobox illegal selection
2003-12-28 AP 1.2.0 Fix for pgDatabase::database crash
2003-12-10 AP 1.2.0 serial/bigserial datatype for ALTER TABLE; can create new
sequence/dependency
2003-12-09 AP 1.2.0 Fix for Tagalog language
2003-12-08 AP 1.2.0 Refactor virtual pgObject::GetDatabase()
2003-12-08 AP 1.2.0 Rewrite of schema qualifier suppression: configurable or
search_path
2003-12-08 DP 1.2.0 Prompt to save changes before opening SQL files.
2003-12-08 AP 1.2.0 Query tool: display of inserted OIDs
2003-12-08 AP 1.2.0 pgAgent schema, changed system schema discovery
2003-12-05 AP 1.2.0 allow all 'p' types except any,trigger,language_handler
as return types for functions
2003-12-03 AP 1.2.0 fix connect to MULE_INTERNAL db
2003-12-02 AP 1.2.0 fix acl property display
2003-12-02 AP 1.2.0 another fix closing Query Tool
2003-12-01 AP 1.2.0 add display of superuser context settings
2003-11-30 AP 1.2.0 handle covering index for Foreign Keys
2003-11-30 AP 1.2.0 fix closing Query Tool while query is running
2003-11-30 AP 1.2.0 fix error message when SET client_encoding fails
2003-11-28 HS 1.2.0 Fix case sensitive keyword highlighting.
2003-11-28 DP 1.0.2 Update PostgreSQL docs to 7.4
2003-11-26 AP 1.0.2 fix notice processing for pgQueryThread
2003-11-24 AP 1.2.0 refactoring stats/depends: populate on demand
2003-11-24 AP 1.2.0 remember property dialog sizes (refactoring syssettings
for pos/size)
2003-11-16 AP 1.2.0 Fix file writing
2003-11-14 DP 1.2.0 Allow creation/display of functions with class data types.
2003-11-11 AP 1.2.0 refactoring: ctlListView
2003-11-11 AP 1.2.0 Show referencing/referenced objects
2003-11-05 AP 1.2.0 File format (won't change existing format)
2003-10-31 AP 1.2.0 Rows affected in query tool
2003-10-31 AP 1.2.0 counting non-constraint FKs for databases
2003-10-26 AP 1.2.0 precompiled headers under msw
2003-10-23 AP 1.0.2 another SQL_ASCII fix
2003-10-23 AP 1.2.0 Fix estimated rowcount
2003-10-20 AP 1.2.0 wxTimeSpinCtrl
2003-10-20 HS 1.2.0 Added support for column statistics.
2003-10-19 AP 1.2.0 Loading of ctlSQLBox from resource
2003-10-19 AP 1.2.0 User expiry
2003-10-18 DP 1.2.0 Allow filtering of data in the edit grid.
2003-10-17 DP 1.2.0 Allow sorting of data in the edit grid.
2003-10-16 AHP 1.2.0 Fix SSL compile bug.
2003-10-14 DP 1.0.1 Update PostgreSQL docs to 7.4Beta4
2003-10-13 AP 1.0.1 Fix ReadOnly security
2003-10-13 AP 1.0.1 Fix encoding when connecting
2003-10-10 AP 1.2.0 Query Tool execute to file
2003-10-07 DP 1.0.1 Set cache value correctly when creating sequences.
2003-10-07 DP 1.2.0 Handle array of definable length types correctly e.g.
numeric(12,8)[].
2003-10-07 DP 1.0.1 Display/use char instead of bpchar.
2003-10-07 AP 1.0.1 Fixed the frogfrog constraint (doubling of names).
2003-10-06 AP 1.2.0 Check if PQfnumber wants quoting or not
2003-10-06 AP 1.0.1 Fix Unique Constraint creation
2003-10-06 AP 1.2.0 Fix DlgUnit sizing, review of XRC files
2003-10-03 DP 1.2.0 When connecting to a new server, if logon fails remember
description as well as other info.
2003-10-03 DP 1.2.0 Added locks tab to server status window.
2003-10-03 DP 1.0.1 Reconnect to databases properly after failed attempt to
drop.
2003-10-01 AP 1.2.0 generic TreeItem renderer for gtk [+] / [-]
2003-10-01 AP 1.0.1 client encoding SQL_ASCII for server SQL_ASCII
2003-10-01 DP 1.0.1 Correctly quote table names when creating indexes.
2003-10-01 AP 1.2.0 fonts determine metrics for dialog resizing
2003-09-30 HS 1.0.1 Display new triggers correctly in the treeview.
2003-09-30 DP 1.0.1 Allow creation of triggers with functions in schemas not
in the search path.
2003-09-28 AP 1.2.0 Statistics translatable
2003-09-26 HS 1.0.0 Handle Primary Key comments correctly.
2003-09-24 AP 1.0.0 rule condition fix
2003-09-26 HS 1.0.0 column quoting when reading pgSet
2003-09-14 AP 1.0.0 document-here support for pgsql8.0
2003-09-12 HS 1.0.0 Display and edit check constraint comments properly.
2003-09-12 HS 1.0.0 Display fkey comments properly.
2003-09-11 JMP 1.0.0 RPM packages now install pgAdmin3 icon.
2003-09-11 JMP 1.0.0 SRPM package should rebuild anywhere.
2003-09-10 AP 1.0.0 correct quoting in dlg Operator, support schema qualified
merge ops.
2003-09-10 AHP 1.0.0 Search for PostgreSQL includes in /usr/include and
/usr/include/pgsql.
2003-09-09 HS 1.0.0 Populate Operator combos properly.
2003-09-09 HS 1.0.0 Retrieve freshly created conversions correctly.
2003-09-09 HS 1.0.0 Correctly quote the ANY keyword in aggregate definitions.
2003-09-09 HS 1.0.0 Fix for casts with created WITHOUT FUNCTION (binary
compatible).
2003-09-09 AP 1.0.0 fix grid for tables with multicolumn pk
2003-09-08 HS 1.0.0 Don't crash when selecting SQL command help when not
connected to a server
2003-09-08 AP 1.0.0 update query tool toolbar after clipboard cut/copy
2003-09-08 AP 1.0.0 fix trigger dialog for multiple events
2003-09-08 AP 1.0.0 export and option dialog partially bigger
2003-09-06 AP 1.0.0 missed some strings for translation
2003-09-03 AP 1.0.0 fixing the grid's edit control
2003-09-03 AP 1.0.0 enabling menu etc from a collection's properties listview,
including a bugfix if the object wasn't expanded and still
had a dummy child.
2003-09-02 AP 0.9.3 include public trigger functions
2003-08-29 AP 0.9.3 frmEditGrid: double click on labels resizes column or row
2003-08-28 AP 0.9.3 handle editor scrolling in frmEditGrid
2003-08-28 AP 0.9.3 Fix numeric truncation in frmEditGrid
2003-08-25 AP 0.9.3 SSL support for win32.
2003-08-25 AP 0.9.3 save SSL option under Servers/SSL%d.
2003-08-24 AP 0.9.3 Provide dummy child item to make [+] appear in tree for
table and view.
2003-08-24 AP 0.9.3 proxy option.
2003-08-24 AP 0.9.3 Shift-F10 in tree control for context menu.
2003-08-23 AP 0.9.3 Fixed missing comments and function arguments.
2003-08-21 AP 0.9.3 Using EVT_TEXT for combobox selchange events.
2003-08-21 AP 0.9.3 encoding names read from backend, removed from resource.
2003-08-19 DP 0.9.3 Prevent comments on view columns causing display problems.
2003-08-19 MP 0.9.3 Updated wxWindows-pgAdmin3 to resolve FreeBSD 5.1 locale
search bug.
2003-08-18 DP 0.9.3 Correctly quote primary key name in Edit Grid. Was
preventing viewing of data in some tables.
2003-08-17 AP 0.9.3 added REINDEX, frmVacuum->frmMaintenance.
2003-08-15 AP 0.9.3 added SSL-support.
2003-08-15 AP 0.9.3 Wording: "maintenance" instead of "reorganize".
2003-08-14 DP 0.9.3 Shorten minimum length of rule definition to allow
'NOTHING'.
2003-08-14 DP 0.9.3 Add DROP SQL for rule definitions.
2003-08-13 AP 0.9.3 Added VERSION Resource for win32.
2003-08-11 DP 0.9.3 Use compiled HTML help file for Help on windows.
2003-08-11 AP 0.9.3 Added "Change column" in table property.
2003-08-11 AP 0.9.3 Corrected SQL generation for table property.
2003-08-11 AP 0.9.2 Select current item if right click on tree item.
2003-08-11 AP 0.9.2 Added win32 version resource.
2003-08-11 AP 0.9.2 Corrected missing quoting for FK.
2003-08-08 AP 0.9.2 Allow tables without columns for 7.4
2003-08-08 AP 0.9.2 Support of several new 7.4 features.
2003-08-08 DP 0.9.2 Added missing helpfile images to Win32 Installer.
2003-08-07 AP 0.9.2 help system cleanups, support of CHM help for win32.
2003-08-07 AP 0.9.2 Added missing comment in domain property.
2003-08-06 DP 0.9.2 Bumped version number.
|