Possible bug in postgres || libpq - Mailing list pgsql-bugs

From fredrik chabot
Subject Possible bug in postgres || libpq
Date
Msg-id 382734D6.D2AB8401@f6.nl
Whole thread Raw
List pgsql-bugs
Hi

I'm started to try to use postgres as a backend for an bussiness
application run up to what i think could be a bug in either postgres or
libpq

Mainly a

> NOTICE:  Buffer Leak: [012] (freeNext=-3, freePrev=-3, relname=dsrbk,
> blockNum=0, flags=0x4, refcount=64 3)

or similar following a COMMIT and a core after some time.

It is reproducable when running the same commands thrue the psql util.

Log included, i know it isn't pretty sql code but it should work right?
All cursors are on unique indexes.

Iff this is a mailing list of some sort pls cc any answer to my e-mail
address.

Thank's
---
Met vriendelijke groet,

Fredrik Chabot
BEGIN;
--     6 | 942067922.071267 - 942067922.073599 | 0.002332 | 0.002332
DECLARE c_000 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier afsluiten'
); 
--   123 | 942067922.073762 - 942067922.365804 | 0.292042 | 0.294374
FETCH 1 IN c_000;
--    17 | 942067922.365954 - 942067922.378620 | 0.012666 | 0.307040
CLOSE c_000;
--    12 | 942067923.048869 - 942067923.049762 | 0.000893 | 0.307933
DECLARE c_001 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'offerte maken' ) ;
--   119 | 942067923.049909 - 942067923.054671 | 0.004762 | 0.312695
FETCH 1 IN c_001;
--    17 | 942067923.054792 - 942067923.055930 | 0.001138 | 0.313833
CLOSE c_001;
--    12 | 942067923.130952 - 942067923.131923 | 0.000971 | 0.314804
DECLARE c_002 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'infoblad' ) ;
--   114 | 942067923.132066 - 942067923.134337 | 0.002271 | 0.317075
FETCH 1 IN c_002;
--    17 | 942067923.134492 - 942067923.135552 | 0.001060 | 0.318135
DECLARE c_003 CURSOR FOR SELECT "afd", "txt", "sta", "stb", "stc", "std", "ste" FROM dsafd WHERE ( "afd" = 'fb' ) ;
--   115 | 942067925.413073 - 942067925.502053 | 0.088980 | 0.407115
FETCH 1 IN c_003;
--    17 | 942067925.502188 - 942067925.549679 | 0.047491 | 0.454606
CLOSE c_002;
--    12 | 942067925.549942 - 942067925.550595 | 0.000653 | 0.455259
DECLARE c_004 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier afdeling
fb') ; 
--   125 | 942067925.550736 - 942067925.553903 | 0.003167 | 0.458426
FETCH 1 IN c_004;
--    17 | 942067925.554022 - 942067925.555236 | 0.001214 | 0.459640
DECLARE c_005 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067925.555980 - 942067925.572755 | 0.016775 | 0.476415
FETCH 1 IN c_005;
--    17 | 942067925.572886 - 942067925.582957 | 0.010071 | 0.486486
DECLARE c_006 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ;
--    82 | 942067925.583220 - 942067925.645981 | 0.062761 | 0.549247
FETCH 1 IN c_006;
--    17 | 942067925.646117 - 942067925.647173 | 0.001056 | 0.550303
CLOSE c_005;
--    12 | 942067925.647400 - 942067925.647975 | 0.000575 | 0.550878
DECLARE c_007 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067925.648111 - 942067925.650894 | 0.002783 | 0.553661
FETCH 1 IN c_007;
--    17 | 942067925.651036 - 942067925.652091 | 0.001055 | 0.554716
CLOSE c_006;
--    12 | 942067925.652276 - 942067925.652845 | 0.000569 | 0.555285
DECLARE c_008 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ;
--    82 | 942067925.652977 - 942067925.654883 | 0.001906 | 0.557191
FETCH 1 IN c_008;
--    17 | 942067925.655001 - 942067925.655894 | 0.000893 | 0.558084
CLOSE c_007;
--    12 | 942067926.382828 - 942067926.383656 | 0.000828 | 0.558912
DECLARE c_009 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067926.383834 - 942067926.386734 | 0.002900 | 0.561812
FETCH 1 IN c_009;
--    17 | 942067926.386855 - 942067926.387820 | 0.000965 | 0.562777
CLOSE c_008;
--    12 | 942067926.388014 - 942067926.388587 | 0.000573 | 0.563350
DECLARE c_010 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ;
--    82 | 942067926.388717 - 942067926.390598 | 0.001881 | 0.565231
FETCH 1 IN c_010;
--    17 | 942067926.390716 - 942067926.391669 | 0.000953 | 0.566184
CLOSE c_009;
--    12 | 942067926.391880 - 942067926.392447 | 0.000567 | 0.566751
DECLARE c_011 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067926.392576 - 942067926.395185 | 0.002609 | 0.569360
FETCH 1 IN c_011;
--    17 | 942067926.395305 - 942067926.396223 | 0.000918 | 0.570278
CLOSE c_010;
--    12 | 942067926.396468 - 942067926.397049 | 0.000581 | 0.570859
DECLARE c_012 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ;
--    82 | 942067926.397182 - 942067926.399069 | 0.001887 | 0.572746
FETCH 1 IN c_012;
--    17 | 942067926.399190 - 942067926.400118 | 0.000928 | 0.573674
CLOSE c_011;
--    12 | 942067926.400328 - 942067926.400901 | 0.000573 | 0.574247
DECLARE c_013 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067926.401761 - 942067926.404424 | 0.002663 | 0.576910
FETCH 1 IN c_013;
--    17 | 942067926.404547 - 942067926.405480 | 0.000933 | 0.577843
CLOSE c_012;
--    12 | 942067926.405670 - 942067926.406242 | 0.000572 | 0.578415
DECLARE c_014 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ;
--    82 | 942067926.406376 - 942067926.408232 | 0.001856 | 0.580271
FETCH 1 IN c_014;
--    17 | 942067926.408352 - 942067926.409238 | 0.000886 | 0.581157
CLOSE c_013;
--    12 | 942067926.409509 - 942067926.410099 | 0.000590 | 0.581747
DECLARE c_015 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067926.410231 - 942067926.412881 | 0.002650 | 0.584397
FETCH 1 IN c_015;
--    17 | 942067926.413004 - 942067926.413934 | 0.000930 | 0.585327
CLOSE c_014;
--    12 | 942067926.414119 - 942067926.414689 | 0.000570 | 0.585897
DECLARE c_016 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ;
--    82 | 942067926.414821 - 942067926.416669 | 0.001848 | 0.587745
FETCH 1 IN c_016;
--    17 | 942067926.416789 - 942067926.417676 | 0.000887 | 0.588632
DECLARE mycursor CURSOR FOR SELECT "afd", "dss", "usr", "dat", "anc", "rel", "refa", "refb", "refc", "refd", "sta",
"stb","stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse", "vko", "vkk", "nko", "nkk", "vzo", "vzk", "daa", "dab"
FROMdskop WHERE ( "afd" = 'fb' and "dss" >=         0 )  or ( "afd" > 'fb' )  ORDER BY "afd" ASC , "dss" ASC ; 
--   345 | 942067927.163193 - 942067927.302727 | 0.139534 | 0.728166
FETCH 15 in mycursor;
--    21 | 942067927.302866 - 942067927.855583 | 0.552717 | 1.280883
FETCH 14 in mycursor;
--    21 | 942067928.562389 - 942067928.568760 | 0.006371 | 1.287254
CLOSE c_004;
--    12 | 942067929.502468 - 942067929.503137 | 0.000669 | 1.287923
CLOSE c_003;
--    12 | 942067929.503252 - 942067929.503924 | 0.000672 | 1.288595
CLOSE c_015;
--    12 | 942067929.504033 - 942067929.504585 | 0.000552 | 1.289147
CLOSE c_016;
--    12 | 942067929.504690 - 942067929.505236 | 0.000546 | 1.289693
COMMIT;
NOTICE:  Buffer Leak: [012] (freeNext=-3, freePrev=-3, relname=dsrbk, blockNum=0, flags=0x4, refcount=64 3)
--     7 | 942067929.505331 - 942067929.506955 | 0.001624 | 1.291317
BEGIN;
--     6 | 942067929.507357 - 942067929.507982 | 0.000625 | 1.291942
DECLARE c_017 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier afdeling
fb') ; 
--   125 | 942067929.508118 - 942067929.511895 | 0.003777 | 1.295719
FETCH 1 IN c_017;
--    17 | 942067929.512048 - 942067929.513329 | 0.001281 | 1.297000
DECLARE c_018 CURSOR FOR SELECT "afd", "dss", "usr", "dat", "anc", "rel", "refa", "refb", "refc", "refd", "sta", "stb",
"stc","std", "ste", "fsa", "fsb", "fsc", "fsd", "fse", "vko", "vkk", "nko", "nkk", "vzo", "vzk", "daa", "dab" FROM
dskopWHERE ( "afd" = 'fb' and "dss" =        61 ) ; 
--   288 | 942067929.513675 - 942067929.520480 | 0.006805 | 1.303805
FETCH 1 IN c_018;
--    17 | 942067929.520603 - 942067929.523423 | 0.002820 | 1.306625
DECLARE c_019 CURSOR FOR SELECT "afd", "txt", "sta", "stb", "stc", "std", "ste" FROM dsafd WHERE ( "afd" = 'fb' ) ;
--   115 | 942067929.523690 - 942067929.526013 | 0.002323 | 1.308948
FETCH 1 IN c_019;
--    17 | 942067929.526132 - 942067929.527071 | 0.000939 | 1.309887
DECLARE c_020 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067929.527773 - 942067929.530716 | 0.002943 | 1.312830
FETCH 1 IN c_020;
--    17 | 942067929.530865 - 942067929.533120 | 0.002255 | 1.315085
DECLARE c_021 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ;
--    82 | 942067929.533322 - 942067929.535316 | 0.001994 | 1.317079
FETCH 1 IN c_021;
--    17 | 942067929.535429 - 942067929.536398 | 0.000969 | 1.318048
CLOSE c_020;
--    12 | 942067929.536602 - 942067929.537204 | 0.000602 | 1.318650
DECLARE c_022 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067929.537340 - 942067929.540150 | 0.002810 | 1.321460
FETCH 1 IN c_022;
--    17 | 942067929.540267 - 942067929.541413 | 0.001146 | 1.322606
DECLARE c_023 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" =        61 and
"rbk"= 'zknm' ) ; 
--   135 | 942067929.541638 - 942067929.567375 | 0.025737 | 1.348343
FETCH 1 IN c_023;
--    17 | 942067929.567500 - 942067929.610969 | 0.043469 | 1.391812
CLOSE c_022;
--    12 | 942067929.611222 - 942067929.611920 | 0.000698 | 1.392510
DECLARE c_024 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067929.612060 - 942067929.614951 | 0.002891 | 1.395401
FETCH 1 IN c_024;
--    17 | 942067929.615087 - 942067929.616152 | 0.001065 | 1.396466
CLOSE c_021;
--    12 | 942067929.616332 - 942067929.616926 | 0.000594 | 1.397060
DECLARE c_025 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ;
--    82 | 942067929.617061 - 942067929.618970 | 0.001909 | 1.398969
FETCH 1 IN c_025;
--    17 | 942067929.619085 - 942067929.620003 | 0.000918 | 1.399887
CLOSE c_024;
--    12 | 942067929.620205 - 942067929.620796 | 0.000591 | 1.400478
DECLARE c_026 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067929.620930 - 942067929.624025 | 0.003095 | 1.403573
FETCH 1 IN c_026;
--    17 | 942067929.624140 - 942067929.625106 | 0.000966 | 1.404539
CLOSE c_023;
--    12 | 942067929.625343 - 942067929.626051 | 0.000708 | 1.405247
DECLARE c_027 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" =        61 and
"rbk"= 'team' ) ; 
--   135 | 942067929.626187 - 942067929.629731 | 0.003544 | 1.408791
FETCH 1 IN c_027;
--    17 | 942067929.629849 - 942067929.630946 | 0.001097 | 1.409888
CLOSE c_026;
--    12 | 942067930.255096 - 942067930.255787 | 0.000691 | 1.410579
DECLARE c_028 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067930.255923 - 942067930.258988 | 0.003065 | 1.413644
FETCH 1 IN c_028;
--    17 | 942067930.259102 - 942067930.260110 | 0.001008 | 1.414652
CLOSE c_025;
--    12 | 942067930.260299 - 942067930.260895 | 0.000596 | 1.415248
DECLARE c_029 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ;
--    82 | 942067930.261443 - 942067930.263417 | 0.001974 | 1.417222
FETCH 1 IN c_029;
--    17 | 942067930.263563 - 942067930.264530 | 0.000967 | 1.418189
CLOSE c_028;
--    12 | 942067930.264730 - 942067930.265330 | 0.000600 | 1.418789
DECLARE c_030 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067930.265459 - 942067930.268189 | 0.002730 | 1.421519
FETCH 1 IN c_030;
--    17 | 942067930.268300 - 942067930.269290 | 0.000990 | 1.422509
CLOSE c_029;
--    12 | 942067930.269467 - 942067930.270055 | 0.000588 | 1.423097
DECLARE c_031 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ;
--    82 | 942067930.270185 - 942067930.272871 | 0.002686 | 1.425783
FETCH 1 IN c_031;
--    17 | 942067930.272982 - 942067930.273916 | 0.000934 | 1.426717
CLOSE c_019;
--    12 | 942067930.673025 - 942067930.673590 | 0.000565 | 1.427282
DECLARE c_032 CURSOR FOR SELECT "afd", "txt", "sta", "stb", "stc", "std", "ste" FROM dsafd WHERE ( "afd" = 'fb' ) ;
--   115 | 942067930.673721 - 942067930.676058 | 0.002337 | 1.429619
FETCH 1 IN c_032;
--    17 | 942067930.676254 - 942067930.677222 | 0.000968 | 1.430587
CLOSE c_017;
--    12 | 942067930.677440 - 942067930.678085 | 0.000645 | 1.431232
DECLARE c_033 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier afdeling
fb') ; 
--   125 | 942067930.678224 - 942067930.680550 | 0.002326 | 1.433558
FETCH 1 IN c_033;
--    17 | 942067930.680669 - 942067930.682129 | 0.001460 | 1.435018
CLOSE c_030;
--    12 | 942067930.682692 - 942067930.683361 | 0.000669 | 1.435687
DECLARE c_034 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067930.683498 - 942067930.686268 | 0.002770 | 1.438457
FETCH 1 IN c_034;
--    17 | 942067930.686384 - 942067930.687442 | 0.001058 | 1.439515
CLOSE c_031;
--    12 | 942067930.687630 - 942067930.688240 | 0.000610 | 1.440125
DECLARE c_035 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ;
--    82 | 942067930.688376 - 942067930.690294 | 0.001918 | 1.442043
FETCH 1 IN c_035;
--    17 | 942067930.690411 - 942067930.692015 | 0.001604 | 1.443647
CLOSE c_034;
--    12 | 942067930.692217 - 942067930.692850 | 0.000633 | 1.444280
DECLARE c_036 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067930.692986 - 942067930.695687 | 0.002701 | 1.446981
FETCH 1 IN c_036;
--    17 | 942067930.695804 - 942067930.696804 | 0.001000 | 1.447981
CLOSE c_035;
--    12 | 942067930.696987 - 942067930.697599 | 0.000612 | 1.448593
DECLARE c_037 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ;
--    82 | 942067930.697733 - 942067930.699588 | 0.001855 | 1.450448
FETCH 1 IN c_037;
--    17 | 942067930.699706 - 942067930.700625 | 0.000919 | 1.451367
CLOSE c_036;
--    12 | 942067931.092810 - 942067931.093485 | 0.000675 | 1.452042
DECLARE c_038 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067931.093622 - 942067931.096847 | 0.003225 | 1.455267
FETCH 1 IN c_038;
--    17 | 942067931.096965 - 942067931.097994 | 0.001029 | 1.456296
CLOSE c_037;
--    12 | 942067931.098182 - 942067931.098791 | 0.000609 | 1.456905
DECLARE c_039 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ;
--    82 | 942067931.098924 - 942067931.100829 | 0.001905 | 1.458810
FETCH 1 IN c_039;
--    17 | 942067931.100946 - 942067931.102063 | 0.001117 | 1.459927
CLOSE c_038;
--    12 | 942067931.102269 - 942067931.102864 | 0.000595 | 1.460522
DECLARE c_040 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067931.102996 - 942067931.105840 | 0.002844 | 1.463366
FETCH 1 IN c_040;
--    17 | 942067931.105956 - 942067931.106942 | 0.000986 | 1.464352
CLOSE c_039;
--    12 | 942067931.107121 - 942067931.107722 | 0.000601 | 1.464953
DECLARE c_041 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ;
--    82 | 942067931.107853 - 942067931.109743 | 0.001890 | 1.466843
FETCH 1 IN c_041;
--    17 | 942067931.109857 - 942067931.110810 | 0.000953 | 1.467796
CLOSE c_040;
--    12 | 942067931.111630 - 942067931.112281 | 0.000651 | 1.468447
DECLARE c_042 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067931.112413 - 942067931.115128 | 0.002715 | 1.471162
FETCH 1 IN c_042;
--    17 | 942067931.115351 - 942067931.116379 | 0.001028 | 1.472190
CLOSE c_041;
--    12 | 942067931.116559 - 942067931.117169 | 0.000610 | 1.472800
DECLARE c_043 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ;
--    82 | 942067931.117299 - 942067931.119155 | 0.001856 | 1.474656
FETCH 1 IN c_043;
--    17 | 942067931.119269 - 942067931.120191 | 0.000922 | 1.475578
CLOSE c_042;
--    12 | 942067931.120396 - 942067931.121155 | 0.000759 | 1.476337
DECLARE c_044 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067931.121288 - 942067931.124044 | 0.002756 | 1.479093
FETCH 1 IN c_044;
--    17 | 942067931.124160 - 942067931.125280 | 0.001120 | 1.480213
CLOSE c_043;
--    12 | 942067931.125461 - 942067931.126077 | 0.000616 | 1.480829
DECLARE c_045 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ;
--    82 | 942067931.126207 - 942067931.128058 | 0.001851 | 1.482680
FETCH 1 IN c_045;
--    17 | 942067931.128174 - 942067931.129103 | 0.000929 | 1.483609
DECLARE mycursor CURSOR FOR SELECT "afd", "dss", "usr", "dat", "anc", "rel", "refa", "refb", "refc", "refd", "sta",
"stb","stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse", "vko", "vkk", "nko", "nkk", "vzo", "vzk", "daa", "dab"
FROMdskop WHERE ( "afd" = 'fb' and "dss" >=         0 )  or ( "afd" > 'fb' )  ORDER BY "afd" ASC , "dss" ASC ; 
--   345 | 942067931.343068 - 942067931.352445 | 0.009377 | 1.492986
FETCH 15 in mycursor;
--    21 | 942067931.352579 - 942067931.681772 | 0.329193 | 1.822179
FETCH 14 in mycursor;
--    21 | 942067932.241788 - 942067932.247901 | 0.006113 | 1.828292
FETCH 14 in mycursor;
--    21 | 942067932.562508 - 942067932.568717 | 0.006209 | 1.834501
CLOSE c_033;
--    12 | 942067933.352205 - 942067933.352882 | 0.000677 | 1.835178
CLOSE c_018;
--    12 | 942067933.353000 - 942067933.353714 | 0.000714 | 1.835892
CLOSE c_032;
--    12 | 942067933.353827 - 942067933.354384 | 0.000557 | 1.836449
CLOSE c_044;
--    12 | 942067933.354497 - 942067933.355046 | 0.000549 | 1.836998
CLOSE c_045;
--    12 | 942067933.355157 - 942067933.355715 | 0.000558 | 1.837556
CLOSE c_027;
--    12 | 942067933.355827 - 942067933.356409 | 0.000582 | 1.838138
COMMIT;
NOTICE:  Buffer Leak: [012] (freeNext=-3, freePrev=-3, relname=dsrbk, blockNum=0, flags=0x4, refcount=73 3)
--     7 | 942067933.356511 - 942067933.357929 | 0.001418 | 1.839556
BEGIN;
--     6 | 942067933.358296 - 942067933.358924 | 0.000628 | 1.840184
DECLARE c_046 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier afdeling
fb') ; 
--   125 | 942067933.359067 - 942067933.363003 | 0.003936 | 1.844120
FETCH 1 IN c_046;
--    17 | 942067933.363125 - 942067933.364413 | 0.001288 | 1.845408
DECLARE c_047 CURSOR FOR SELECT "afd", "dss", "usr", "dat", "anc", "rel", "refa", "refb", "refc", "refd", "sta", "stb",
"stc","std", "ste", "fsa", "fsb", "fsc", "fsd", "fse", "vko", "vkk", "nko", "nkk", "vzo", "vzk", "daa", "dab" FROM
dskopWHERE ( "afd" = 'fb' and "dss" =        77 ) ; 
--   288 | 942067933.364765 - 942067933.372189 | 0.007424 | 1.852832
FETCH 1 IN c_047;
--    17 | 942067933.372313 - 942067933.374445 | 0.002132 | 1.854964
DECLARE c_048 CURSOR FOR SELECT "afd", "txt", "sta", "stb", "stc", "std", "ste" FROM dsafd WHERE ( "afd" = 'fb' ) ;
--   115 | 942067933.374751 - 942067933.377074 | 0.002323 | 1.857287
FETCH 1 IN c_048;
--    17 | 942067933.377195 - 942067933.378140 | 0.000945 | 1.858232
DECLARE c_049 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067933.378799 - 942067933.402605 | 0.023806 | 1.882038
FETCH 1 IN c_049;
--    17 | 942067933.402756 - 942067933.403903 | 0.001147 | 1.883185
DECLARE c_050 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ;
--    82 | 942067933.404128 - 942067933.406118 | 0.001990 | 1.885175
FETCH 1 IN c_050;
--    17 | 942067933.406237 - 942067933.407207 | 0.000970 | 1.886145
CLOSE c_049;
--    12 | 942067933.407420 - 942067933.408031 | 0.000611 | 1.886756
DECLARE c_051 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067933.408171 - 942067933.410989 | 0.002818 | 1.889574
FETCH 1 IN c_051;
--    17 | 942067933.411130 - 942067933.412094 | 0.000964 | 1.890538
DECLARE c_052 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" =        77 and
"rbk"= 'zknm' ) ; 
--   135 | 942067933.412318 - 942067933.416005 | 0.003687 | 1.894225
FETCH 1 IN c_052;
--    17 | 942067933.416163 - 942067933.418417 | 0.002254 | 1.896479
CLOSE c_051;
--    12 | 942067933.418640 - 942067933.419269 | 0.000629 | 1.897108
DECLARE c_053 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067933.419409 - 942067933.422382 | 0.002973 | 1.900081
FETCH 1 IN c_053;
--    17 | 942067933.422499 - 942067933.423471 | 0.000972 | 1.901053
CLOSE c_050;
--    12 | 942067933.423654 - 942067933.424248 | 0.000594 | 1.901647
DECLARE c_054 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ;
--    82 | 942067933.424388 - 942067933.426306 | 0.001918 | 1.903565
FETCH 1 IN c_054;
--    17 | 942067933.426423 - 942067933.427345 | 0.000922 | 1.904487
CLOSE c_053;
--    12 | 942067933.427544 - 942067933.428145 | 0.000601 | 1.905088
DECLARE c_055 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067933.428282 - 942067933.431055 | 0.002773 | 1.907861
FETCH 1 IN c_055;
--    17 | 942067933.431173 - 942067933.432173 | 0.001000 | 1.908861
CLOSE c_052;
--    12 | 942067933.432382 - 942067933.433017 | 0.000635 | 1.909496
DECLARE c_056 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" =        77 and
"rbk"= 'team' ) ; 
--   135 | 942067933.433163 - 942067933.437002 | 0.003839 | 1.913335
FETCH 1 IN c_056;
--    17 | 942067933.437126 - 942067933.438270 | 0.001144 | 1.914479
CLOSE c_055;
--    12 | 942067934.573200 - 942067934.573843 | 0.000643 | 1.915122
DECLARE c_057 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   0 ) ; 
--   138 | 942067934.573980 - 942067934.577026 | 0.003046 | 1.918168
FETCH 1 IN c_057;
--    17 | 942067934.577142 - 942067934.578162 | 0.001020 | 1.919188
CLOSE c_054;
--    12 | 942067934.578351 - 942067934.578956 | 0.000605 | 1.919793
DECLARE c_058 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'zknm' ) ;
--    82 | 942067934.579094 - 942067934.581199 | 0.002105 | 1.921898
FETCH 1 IN c_058;
--    17 | 942067934.581314 - 942067934.582291 | 0.000977 | 1.922875
CLOSE c_056;
--    12 | 942067934.582487 - 942067934.583126 | 0.000639 | 1.923514
DECLARE c_059 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" =        77 and
"rbk"= 'zknm' ) ; 
--   135 | 942067934.583258 - 942067934.586832 | 0.003574 | 1.927088
FETCH 1 IN c_059;
--    17 | 942067934.586949 - 942067934.588116 | 0.001167 | 1.928255
CLOSE c_046;
--    12 | 942067934.723540 - 942067934.724291 | 0.000751 | 1.929006
CLOSE c_047;
--    12 | 942067934.724406 - 942067934.725071 | 0.000665 | 1.929671
CLOSE c_048;
--    12 | 942067934.725185 - 942067934.725739 | 0.000554 | 1.930225
CLOSE c_057;
--    12 | 942067934.725851 - 942067934.726389 | 0.000538 | 1.930763
CLOSE c_058;
--    12 | 942067934.726504 - 942067934.727052 | 0.000548 | 1.931311
CLOSE c_059;
--    12 | 942067934.727165 - 942067934.727743 | 0.000578 | 1.931889
COMMIT;
NOTICE:  Buffer Leak: [061] (freeNext=-3, freePrev=-3, relname=dsafr, blockNum=0, flags=0x4, refcount=8 3)
--     7 | 942067934.727870 - 942067934.728713 | 0.000843 | 1.932732
BEGIN;
--     6 | 942067934.728791 - 942067934.729337 | 0.000546 | 1.933278
UPDATE dsrbi SET "afd" = 'fb', "dss" =        77, "rbk" = 'zknm', "ref" = 'bowling' WHERE ( "afd" = 'fb' and "dss" =
   77 and "rbk" = 'zknm' ) ; 
--   149 | 942067934.729570 - 942067934.960004 | 0.230434 | 2.163712
COMMIT;
--     7 | 942067934.960173 - 942067934.963364 | 0.003191 | 2.166903
BEGIN;
--     6 | 942067934.963560 - 942067934.964195 | 0.000635 | 2.167538
DECLARE c_060 CURSOR FOR SELECT "afd", "vnr", "rbk", "sta", "stb", "stc", "std", "ste" FROM dsafr WHERE ( "afd" = 'fb'
and"vnr" =   1 ) ; 
--   138 | 942067934.964335 - 942067934.968985 | 0.004650 | 2.172188
FETCH 1 IN c_060;
--    17 | 942067934.969105 - 942067934.970128 | 0.001023 | 2.173211
DECLARE c_061 CURSOR FOR SELECT "rbk", "oms" FROM dsrbk WHERE ( "rbk" = 'team' ) ;
--    82 | 942067934.970337 - 942067934.980919 | 0.010582 | 2.183793
FETCH 1 IN c_061;
--    17 | 942067934.981193 - 942067934.982232 | 0.001039 | 2.184832
DECLARE c_062 CURSOR FOR SELECT "afd", "dss", "rbk", "ref" FROM dsrbi WHERE ( "afd" = 'fb' and "dss" =        77 and
"rbk"= 'team' ) ; 
--   135 | 942067934.982449 - 942067934.986014 | 0.003565 | 2.188397
FETCH 1 IN c_062;
--    17 | 942067934.986134 - 942067934.987801 | 0.001667 | 2.190064
DECLARE c_063 CURSOR FOR SELECT "rbk", "num", "len", "ref" FROM dsrbc WHERE ( "rbk" = 'team' and "num" = '1' ) ;
--   112 | 942067935.643476 - 942067935.686930 | 0.043454 | 2.233518
FETCH 1 IN c_063;
--    17 | 942067935.687065 - 942067935.722401 | 0.035336 | 2.268854
CLOSE c_063;
--    12 | 942067935.722621 - 942067935.723304 | 0.000683 | 2.269537
DECLARE c_064 CURSOR FOR SELECT "rbk", "num", "len", "ref" FROM dsrbc WHERE ( "rbk" = 'team' and "num" > '1' )  or (
"rbk"> 'team' )  ORDER BY "rbk" ASC , "num" ASC ; 
--   167 | 942067935.723444 - 942067935.727508 | 0.004064 | 2.273601
FETCH 1 IN c_064;
--    17 | 942067935.727668 - 942067935.729082 | 0.001414 | 2.275015
CLOSE c_060;
--    12 | 942067935.730191 - 942067935.730874 | 0.000683 | 2.275698
CLOSE c_061;
--    12 | 942067935.730995 - 942067935.731582 | 0.000587 | 2.276285
CLOSE c_062;
--    12 | 942067935.731698 - 942067935.732293 | 0.000595 | 2.276880
CLOSE c_064;
--    12 | 942067935.732409 - 942067935.732977 | 0.000568 | 2.277448
COMMIT;
NOTICE:  Buffer Leak: [009] (freeNext=-3, freePrev=-3, relname=dsrbi_primary, blockNum=1, flags=0x4, refcount=312 1)
NOTICE:  Buffer Leak: [013] (freeNext=-3, freePrev=-3, relname=dsrbi, blockNum=7, flags=0x4, refcount=44 1)
--     7 | 942067935.733079 - 942067935.734087 | 0.001008 | 2.278456
BEGIN;
--     6 | 942067935.734167 - 942067935.734715 | 0.000548 | 2.279004
UPDATE dsrbi SET "afd" = 'fb', "dss" =        77, "rbk" = 'team', "ref" = '1' WHERE ( "afd" = 'fb' and "dss" =
77and "rbk" = 'team' ) ; 
--   143 | 942067935.734914 - 942067935.766429 | 0.031515 | 2.310519
COMMIT;
--     7 | 942067935.766597 - 942067935.769107 | 0.002510 | 2.313029
BEGIN;
--     6 | 942067935.769221 - 942067935.769844 | 0.000623 | 2.313652
COMMIT;
--     7 | 942067935.769951 - 942067935.770441 | 0.000490 | 2.314142
BEGIN;
--     6 | 942067935.770536 - 942067935.771066 | 0.000530 | 2.314672
UPDATE dskop SET "afd" = 'fb', "dss" =        77, "usr" = 'helga', "dat" = '19971229101433', "anc" =         0, "rel" =
'hogekamp', "refa" = 'Bowlingcentrum', "refb" = 'Lelystad', "refc" = '', "refd" = 'F.O. Harryvan', "sta" =   0, "stb" =
 1, "stc" =   1, "std" =   0, "ste" =   0, "fsa" =   0, "fsb" =   0, "fsc" =   0, "fsd" =   0, "fse" =   0, "vko" =
5577.10,"vkk" =     0.00, "nko" =  5577.10, "nkk" =     0.00, "vzo" =     0.00, "vzk" =     0.00, "daa" =
'0000000000000000',"dab" = '0000000000000000' WHERE ( "afd" = 'fb' and "dss" =        77 ) ; 
--   559 | 942067935.771974 - 942067935.848941 | 0.076967 | 2.391639
COMMIT;
--     7 | 942067935.849079 - 942067935.853348 | 0.004269 | 2.395908
BEGIN;
--     6 | 942067935.940634 - 942067935.941461 | 0.000827 | 2.396735
DECLARE c_065 CURSOR FOR SELECT "res", "sta", "stb", "stc", "std", "ste" FROM alres WHERE ( "res" = 'dossier regels bij
nu') ; 
--   127 | 942067935.941598 - 942067935.945317 | 0.003719 | 2.400454
FETCH 1 IN c_065;
--    17 | 942067935.945437 - 942067935.946720 | 0.001283 | 2.401737
DECLARE c_066 CURSOR FOR SELECT "afd", "dss", "dat", "srt", "akt", "oms", "anc", "vkk", "vkka", "vkkt", "vkkv", "vkkr",
"fav","ibs", "nkk", "nkkv", "nkkr", "vko", "vkoa", "vkot", "vkov", "vkor", "faa", "vbs", "sta", "nko", "nkov", "nkor",
"stb","stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse" FROM dsrgl WHERE ( "afd" = 'fb' and "dss" =        77 and
"dat"< '1999110114321500' )  or ( "afd" = 'fb' and "dss" <        77 )  or ( "afd" < 'fb' )  ORDER BY "afd" DESC ,
"dss"DESC , "dat" DESC ; 
--   501 | 942067935.947220 - 942067936.025509 | 0.078289 | 2.480026
FETCH 1 IN c_066;
--    17 | 942067936.025659 - 942067937.547247 | 1.521588 | 4.001614
DECLARE mycursor CURSOR FOR SELECT "afd", "dss", "dat", "srt", "akt", "oms", "anc", "vkk", "vkka", "vkkt", "vkkv",
"vkkr","fav", "ibs", "nkk", "nkkv", "nkkr", "vko", "vkoa", "vkot", "vkov", "vkor", "faa", "vbs", "sta", "nko", "nkov",
"nkor","stb", "stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse" FROM dsrgl WHERE ( "afd" = 'fb' and "dss" =
77and "dat" >= '19980114135309' )  or ( "afd" = 'fb' and "dss" >        77 )  or ( "afd" > 'fb' )  ORDER BY "afd" ASC ,
"dss"ASC , "dat" ASC ; 
--   500 | 942067937.547907 - 942067937.563798 | 0.015891 | 4.017505
FETCH 11 in mycursor;
--    21 | 942067937.563939 - 942067951.436013 | 13.872074 | 17.889579
CLOSE c_065;
--    12 | 942067953.072421 - 942067953.073304 | 0.000883 | 17.890462
CLOSE c_066;
--    12 | 942067953.073424 - 942067953.074296 | 0.000872 | 17.891334
COMMIT;
--     7 | 942067953.074403 - 942067953.295072 | 0.220669 | 18.112003
BEGIN;
--     6 | 942067953.295201 - 942067953.295944 | 0.000743 | 18.112746
DECLARE mycursor CURSOR FOR SELECT "afd", "dss", "dat", "srt", "akt", "oms", "anc", "vkk", "vkka", "vkkt", "vkkv",
"vkkr","fav", "ibs", "nkk", "nkkv", "nkkr", "vko", "vkoa", "vkot", "vkov", "vkor", "faa", "vbs", "sta", "nko", "nkov",
"nkor","stb", "stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse" FROM dsrgl WHERE ( "afd" = 'fb' and "dss" =
77and "dat" <= '19980114135309' )  or ( "afd" = 'fb' and "dss" <        77 )  or ( "afd" < 'fb' )  ORDER BY "afd" DESC
,"dss" DESC , "dat" DESC ; 
--   503 | 942067953.296340 - 942067953.310466 | 0.014126 | 18.126872
FETCH 11 in mycursor;
--    21 | 942067953.310603 - 942067954.521575 | 1.210972 | 19.337844
COMMIT;
--     7 | 942067954.522578 - 942067954.523757 | 0.001179 | 19.339023
BEGIN;
--     6 | 942067954.523852 - 942067954.524411 | 0.000559 | 19.339582
DECLARE mycursor CURSOR FOR SELECT "afd", "dss", "dat", "srt", "akt", "oms", "anc", "vkk", "vkka", "vkkt", "vkkv",
"vkkr","fav", "ibs", "nkk", "nkkv", "nkkr", "vko", "vkoa", "vkot", "vkov", "vkor", "faa", "vbs", "sta", "nko", "nkov",
"nkor","stb", "stc", "std", "ste", "fsa", "fsb", "fsc", "fsd", "fse" FROM dsrgl WHERE ( "afd" = 'fb' and "dss" =
77and "dat" >= '19971229101433' )  or ( "afd" = 'fb' and "dss" >        77 )  or ( "afd" > 'fb' )  ORDER BY "afd" ASC ,
"dss"ASC , "dat" ASC ; 
--   500 | 942067954.524791 - 942067954.564314 | 0.039523 | 19.379105
FETCH 11 in mycursor;
--    21 | 942067954.564476 - 942067967.715107 | 13.150631 | 32.529736
COMMIT;
--     7 | 942067975.132611 - 942067976.605505 | 1.472894 | 34.002630
BEGIN;
--     6 | 942067976.605797 - 942067976.606633 | 0.000836 | 34.003466
DECLARE c_067 CURSOR FOR SELECT "oms", "srt", "grp", "fi1", "fi2", "fi3", "fi4", "st1", "st2" FROM dsakt WHERE ( "oms"
='vaste post' ) ; 
--   137 | 942067976.606773 - 942067976.814521 | 0.207748 | 34.211214
FETCH 1 IN c_067;
--    17 | 942067976.814668 - 942067976.829493 | 0.014825 | 34.226039
DECLARE c_068 CURSOR FOR SELECT "ste", "afd", "dss", "srt", "oma", "omb", "omc", "vku", "amv", "con", "fqa", "fqb",
"daf","vla", "vlb", "vlc", "vld", "vle", "ref", "dop", "dlv", "tga", "tgb", "dpr", "vwn", "tgc", "dbf", "tgd", "tge",
"a1z","a1n", "a11", "a12", "a13", "a14", "a15" FROM obdtr WHERE ( "ste" =     11012 ) ; 
--   323 | 942067976.830425 - 942067977.018777 | 0.188352 | 34.414391
FETCH 1 IN c_068;
--    17 | 942067977.018919 - 942067977.151796 | 0.132877 | 34.547268
DECLARE c_069 CURSOR FOR SELECT "key", "tel" FROM alftl WHERE ( "key" = 'plkop' ) ;
--    83 | 942067979.084260 - 942067979.143590 | 0.059330 | 34.606598
FETCH 1 IN c_069;
--    17 | 942067979.143727 - 942067979.164500 | 0.020773 | 34.627371
CLOSE c_067;
--    12 | 942067979.164661 - 942067979.165445 | 0.000784 | 34.628155
CLOSE c_068;
--    12 | 942067979.165564 - 942067979.166169 | 0.000605 | 34.628760
CLOSE c_069;
--    12 | 942067979.166284 - 942067979.166842 | 0.000558 | 34.629318
COMMIT;
NOTICE:  Buffer Leak: [016] (freeNext=-3, freePrev=-3, relname=obdtr, blockNum=417, flags=0x4, refcount=1 1)
NOTICE:  Buffer Leak: [044] (freeNext=-3, freePrev=-3, relname=obdtr_primary, blockNum=44, flags=0x4, refcount=1 1)
--     7 | 942067979.166942 - 942067979.175343 | 0.008401 | 34.637719
BEGIN;
--     6 | 942067979.175426 - 942067979.175907 | 0.000481 | 34.638200
UPDATE alftl SET "key" = 'plkop', "tel" =       520 WHERE ( "key" = 'plkop' ) ;
--    79 | 942067979.176061 - 942067979.217475 | 0.041414 | 34.679614
COMMIT;
--     7 | 942067979.217615 - 942067979.219458 | 0.001843 | 34.681457
BEGIN;
--     6 | 942067979.219796 - 942067979.220385 | 0.000589 | 34.682046
DECLARE c_070 CURSOR FOR SELECT "ste", "afd", "dss", "srt", "oma", "omb", "omc", "vku", "amv", "con", "fqa", "fqb",
"daf","vla", "vlb", "vlc", "vld", "vle", "ref", "dop", "dlv", "tga", "tgb", "dpr", "vwn", "tgc", "dbf", "tgd", "tge",
"a1z","a1n", "a11", "a12", "a13", "a14", "a15" FROM obdtr WHERE ( "ste" =     11012 ) ; 
--   323 | 942067979.220540 - 942067979.225083 | 0.004543 | 34.686589
FETCH 1 IN c_070;
--    17 | 942067979.225210 - 942067979.227433 | 0.002223 | 34.688812
CLOSE c_070;
--    12 | 942067979.227674 - 942067979.228349 | 0.000675 | 34.689487
COMMIT;
--     7 | 942067979.228634 - 942067979.229213 | 0.000579 | 34.690066
BEGIN;
--     6 | 942067979.229304 - 942067979.229829 | 0.000525 | 34.690591
UPDATE obdtr SET "ste" =     11012, "afd" = 'fb', "dss" =        77, "srt" = 'VP', "oma" = 'op 1 januari 1998.', "omb"
='2 personen van 00:00 uur tot 08:00 uur a fl. 89,50.', "omc" = '', "vku" =  0.0, "amv" =  0.00, "con" =
'groepsleider',"fqa" =   0, "fqb" =   0, "daf" = '1998010113485600', "vla" =   0, "vlb" =         0, "vlc" =         0,
"vld"=         0, "vle" = 520, "ref" = '', "dop" = '19980114134856', "dlv" = '19980114134856', "tga" =         0, "tgb"
=        0, "dpr" = '0000000000000000', "vwn" = '', "tgc" =         0, "dbf" = '0000000000000000', "tgd" =         0,
"tge"=         0, "a1z" = '', "a1n" =   0, "a11" = '', "a12" = '', "a13" = '', "a14" = '', "a15" = '' WHERE ( "ste" =
 11012 ) ; 
--   718 | 942067979.230853 - 942067979.340244 | 0.109391 | 34.799982
COMMIT;
--     7 | 942067979.340380 - 942067979.348796 | 0.008416 | 34.808398
BEGIN;
--     6 | 942067979.349147 - 942067979.349749 | 0.000602 | 34.809000
DECLARE c_071 CURSOR FOR SELECT "ste", "afd", "dss", "srt", "oma", "omb", "omc", "vku", "amv", "con", "fqa", "fqb",
"daf","vla", "vlb", "vlc", "vld", "vle", "ref", "dop", "dlv", "tga", "tgb", "dpr", "vwn", "tgc", "dbf", "tgd", "tge",
"a1z","a1n", "a11", "a12", "a13", "a14", "a15" FROM obdtr WHERE ( "ste" =     11012 ) ; 
--   323 | 942067979.349906 - 942067979.354375 | 0.004469 | 34.813469
FETCH 1 IN c_071;
--    17 | 942067979.354500 - 942067979.356248 | 0.001748 | 34.815217
DECLARE c_072 CURSOR FOR SELECT "pln", "ste", "afd", "dss", "oms", "std", "end", "vla", "vlb", "vlc", "vld", "vle" FROM
plkopWHERE ( "pln" =       520 ) ; 
--   155 | 942067979.356724 - 942067979.450560 | 0.093836 | 34.909053
FETCH 1 IN c_072;
--    17 | 942067979.450693 - 942067979.485086 | 0.034393 | 34.943446
DECLARE mycursor CURSOR FOR SELECT "pln", "rgl", "snr", "niv", "ste", "afd", "dss", "oms", "std", "end", "frq", "frs",
"wma","wdi", "wwo", "wdo", "wvr", "wza", "wzo", "mns", "tyd", "vla", "vlb", "vlc", "vld", "vle" FROM plrgl WHERE (
"pln"=       520 and "rgl" =   0 and "snr" =         0 and "niv" >=   0 )  or ( "pln" =       520 and "rgl" =   0 and
"snr">         0 )  or ( "pln" =       520 and "rgl" >   0 )  or ( "pln" >       520 )  ORDER BY "pln" ASC , "rgl" ASC
,"snr" ASC , "niv" ASC ; 
--   499 | 942067985.803581 - 942067985.898486 | 0.094905 | 35.038351
FETCH 5 in mycursor;
--    20 | 942067985.898640 - 942067986.031992 | 0.133352 | 35.171703
CLOSE c_071;
--    12 | 942067990.502407 - 942067990.503110 | 0.000703 | 35.172406
CLOSE c_072;
--    12 | 942067990.503232 - 942067990.503952 | 0.000720 | 35.173126
COMMIT;
NOTICE:  Buffer Leak: [032] (freeNext=-3, freePrev=-3, relname=plkop_primary, blockNum=1, flags=0x4, refcount=1 1)
NOTICE:  Buffer Leak: [057] (freeNext=-3, freePrev=-3, relname=plkop, blockNum=7, flags=0x4, refcount=1 1)
--     7 | 942067990.504056 - 942067990.505499 | 0.001443 | 35.174569
BEGIN;
--     6 | 942067990.515930 - 942067990.516560 | 0.000630 | 35.175199
DECLARE mycursor CURSOR FOR SELECT "pln", "rgl", "snr", "zkn", "niv", "ste", "afd", "dss", "std", "end", "frq", "frs",
"wma","wdi", "wwo", "wdo", "wvr", "wza", "wzo", "tyd", "uus", "vla", "vlb", "vlc", "vld", "vle" FROM plrgw WHERE (
"pln"=       520 and "rgl" =   1 and "snr" =         0 and "zkn" = '' and "niv" >=   0 )  or ( "pln" =       520 and
"rgl"=   1 and "snr" =         0 and "zkn" > '' )  or ( "pln" =       520 and "rgl" =   1 and "snr" >         0 )  or (
"pln"=       520 and "rgl" >   1 )  or ( "pln" >       520 )  ORDER BY "pln" ASC , "rgl" ASC , "snr" ASC , "zkn" ASC ,
"niv"ASC ; 
--   605 | 942067990.517028 - 942067991.135802 | 0.618774 | 35.793973
FETCH 8 in mycursor;
--    20 | 942067991.135966 - 942067991.698780 | 0.562814 | 36.356787
COMMIT;
--     7 | 942068001.412908 - 942068001.415601 | 0.002693 | 36.359480
BEGIN;
--     6 | 942068002.413115 - 942068002.413956 | 0.000841 | 36.360321
DECLARE mycursor CURSOR FOR SELECT "pln", "rgl", "snr", "zkn", "niv", "ste", "afd", "dss", "std", "end", "frq", "frs",
"wma","wdi", "wwo", "wdo", "wvr", "wza", "wzo", "tyd", "uus", "vla", "vlb", "vlc", "vld", "vle" FROM plrgw WHERE (
"pln"=       520 and "rgl" =   1 and "snr" =         0 and "zkn" = '' and "niv" >=   0 )  or ( "pln" =       520 and
"rgl"=   1 and "snr" =         0 and "zkn" > '' )  or ( "pln" =       520 and "rgl" =   1 and "snr" >         0 )  or (
"pln"=       520 and "rgl" >   1 )  or ( "pln" >       520 )  ORDER BY "pln" ASC , "rgl" ASC , "snr" ASC , "zkn" ASC ,
"niv"ASC ; 
--   605 | 942068002.414439 - 942068002.807903 | 0.393464 | 36.753785
FETCH 8 in mycursor;
--    20 | 942068002.808062 - 942068003.145200 | 0.337138 | 37.090923
COMMIT;
--     7 | 942068003.812559 - 942068003.815264 | 0.002705 | 37.093628
BEGIN;
--     6 | 942068011.314002 - 942068011.314922 | 0.000920 | 37.094548
DECLARE mycursor CURSOR FOR SELECT "snr", "zkn", "niv", "std", "end", "reg", "vla", "vlb", "vlc", "vld", "vle", "vlf",
"vlg","vlh", "vli", "vlj" FROM plwnp WHERE ( "zkn" = 'DENEE' and "snr" >=         0 )  or ( "zkn" > 'DENEE' )  ORDER BY
"zkn"ASC , "snr" ASC ; 
--   263 | 942068011.315149 - 942068011.365929 | 0.050780 | 37.145328
FETCH 7 in mycursor;
--    20 | 942068011.366063 - 942068011.489367 | 0.123304 | 37.268632
COMMIT;
--     7 | 942068021.501069 - 942068021.505709 | 0.004640 | 37.273272

pgsql-bugs by date:

Previous
From: Eugenio Pierno
Date:
Subject: libplpgsql error on Alpha: solved
Next
From: fredrik chabot
Date:
Subject: Possible bug in postgres || libpq