1
[NO_PID]: ECPGdebug: set to 1
2
[NO_PID]: sqlca: code: 0, state: 00000
3
[NO_PID]: ECPGconnect: opening database regress1 on <DEFAULT> port <DEFAULT>
4
[NO_PID]: sqlca: code: 0, state: 00000
5
[NO_PID]: ecpg_execute on line 46: query: set datestyle to iso; with 0 parameter(s) on connection regress1
6
[NO_PID]: sqlca: code: 0, state: 00000
7
[NO_PID]: ecpg_execute on line 46: using PQexec
8
[NO_PID]: sqlca: code: 0, state: 00000
9
[NO_PID]: ecpg_execute on line 46: OK: SET
10
[NO_PID]: sqlca: code: 0, state: 00000
11
[NO_PID]: ecpg_execute on line 49: query: create table family ( name char ( 8 ) , born integer , age smallint , married date , children integer ); with 0 parameter(s) on connection regress1
12
[NO_PID]: sqlca: code: 0, state: 00000
13
[NO_PID]: ecpg_execute on line 49: using PQexec
14
[NO_PID]: sqlca: code: 0, state: 00000
15
[NO_PID]: ecpg_execute on line 49: OK: CREATE TABLE
16
[NO_PID]: sqlca: code: 0, state: 00000
17
[NO_PID]: ecpg_execute on line 52: query: insert into family ( name , married , children ) values ( 'Mum' , '19870714' , 3 ); with 0 parameter(s) on connection regress1
18
[NO_PID]: sqlca: code: 0, state: 00000
19
[NO_PID]: ecpg_execute on line 52: using PQexec
20
[NO_PID]: sqlca: code: 0, state: 00000
21
[NO_PID]: ecpg_execute on line 52: OK: INSERT 0 1
22
[NO_PID]: sqlca: code: 0, state: 00000
23
[NO_PID]: ecpg_execute on line 53: query: insert into family ( name , born , married , children ) values ( 'Dad' , '19610721' , '19870714' , 3 ); with 0 parameter(s) on connection regress1
24
[NO_PID]: sqlca: code: 0, state: 00000
25
[NO_PID]: ecpg_execute on line 53: using PQexec
26
[NO_PID]: sqlca: code: 0, state: 00000
27
[NO_PID]: ecpg_execute on line 53: OK: INSERT 0 1
28
[NO_PID]: sqlca: code: 0, state: 00000
29
[NO_PID]: ecpg_execute on line 54: query: insert into family ( name , age ) values ( 'Child 1' , 16 ); with 0 parameter(s) on connection regress1
30
[NO_PID]: sqlca: code: 0, state: 00000
31
[NO_PID]: ecpg_execute on line 54: using PQexec
32
[NO_PID]: sqlca: code: 0, state: 00000
33
[NO_PID]: ecpg_execute on line 54: OK: INSERT 0 1
34
[NO_PID]: sqlca: code: 0, state: 00000
35
[NO_PID]: ecpg_execute on line 55: query: insert into family ( name , age ) values ( 'Child 2' , 14 ); with 0 parameter(s) on connection regress1
36
[NO_PID]: sqlca: code: 0, state: 00000
37
[NO_PID]: ecpg_execute on line 55: using PQexec
38
[NO_PID]: sqlca: code: 0, state: 00000
39
[NO_PID]: ecpg_execute on line 55: OK: INSERT 0 1
40
[NO_PID]: sqlca: code: 0, state: 00000
41
[NO_PID]: ecpg_execute on line 56: query: insert into family ( name , age ) values ( 'Child 3' , 9 ); with 0 parameter(s) on connection regress1
42
[NO_PID]: sqlca: code: 0, state: 00000
43
[NO_PID]: ecpg_execute on line 56: using PQexec
44
[NO_PID]: sqlca: code: 0, state: 00000
45
[NO_PID]: ecpg_execute on line 56: OK: INSERT 0 1
46
[NO_PID]: sqlca: code: 0, state: 00000
47
[NO_PID]: ECPGtrans on line 59: action "commit"; connection "regress1"
48
[NO_PID]: sqlca: code: 0, state: 00000
49
[NO_PID]: ecpg_execute on line 62: query: declare cur cursor for select name , born , age , married , children from family; with 0 parameter(s) on connection regress1
50
[NO_PID]: sqlca: code: 0, state: 00000
51
[NO_PID]: ecpg_execute on line 62: using PQexec
52
[NO_PID]: sqlca: code: 0, state: 00000
53
[NO_PID]: ecpg_execute on line 62: OK: DECLARE CURSOR
54
[NO_PID]: sqlca: code: 0, state: 00000
55
[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1
56
[NO_PID]: sqlca: code: 0, state: 00000
57
[NO_PID]: ecpg_execute on line 71: using PQexec
58
[NO_PID]: sqlca: code: 0, state: 00000
59
[NO_PID]: ecpg_execute on line 71: correctly got 1 tuples with 5 fields
60
[NO_PID]: sqlca: code: 0, state: 00000
61
[NO_PID]: ecpg_get_data on line 71: RESULT: Mum offset: -1; array: yes
62
[NO_PID]: sqlca: code: 0, state: 00000
63
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
64
[NO_PID]: sqlca: code: 0, state: 00000
65
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
66
[NO_PID]: sqlca: code: 0, state: 00000
67
[NO_PID]: ecpg_store_result on line 71: allocating memory for 1 tuples
68
[NO_PID]: sqlca: code: 0, state: 00000
69
[NO_PID]: ecpg_get_data on line 71: RESULT: 1987-07-14 offset: -1; array: yes
70
[NO_PID]: sqlca: code: 0, state: 00000
71
[NO_PID]: ecpg_get_data on line 71: RESULT: 3 offset: -1; array: yes
72
[NO_PID]: sqlca: code: 0, state: 00000
73
[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1
74
[NO_PID]: sqlca: code: 0, state: 00000
75
[NO_PID]: ecpg_execute on line 71: using PQexec
76
[NO_PID]: sqlca: code: 0, state: 00000
77
[NO_PID]: ecpg_execute on line 71: correctly got 1 tuples with 5 fields
78
[NO_PID]: sqlca: code: 0, state: 00000
79
[NO_PID]: ecpg_get_data on line 71: RESULT: Dad offset: -1; array: yes
80
[NO_PID]: sqlca: code: 0, state: 00000
81
[NO_PID]: ecpg_get_data on line 71: RESULT: 19610721 offset: -1; array: yes
82
[NO_PID]: sqlca: code: 0, state: 00000
83
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
84
[NO_PID]: sqlca: code: 0, state: 00000
85
[NO_PID]: ecpg_store_result on line 71: allocating memory for 1 tuples
86
[NO_PID]: sqlca: code: 0, state: 00000
87
[NO_PID]: ecpg_get_data on line 71: RESULT: 1987-07-14 offset: -1; array: yes
88
[NO_PID]: sqlca: code: 0, state: 00000
89
[NO_PID]: ecpg_get_data on line 71: RESULT: 3 offset: -1; array: yes
90
[NO_PID]: sqlca: code: 0, state: 00000
91
[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1
92
[NO_PID]: sqlca: code: 0, state: 00000
93
[NO_PID]: ecpg_execute on line 71: using PQexec
94
[NO_PID]: sqlca: code: 0, state: 00000
95
[NO_PID]: ecpg_execute on line 71: correctly got 1 tuples with 5 fields
96
[NO_PID]: sqlca: code: 0, state: 00000
97
[NO_PID]: ecpg_get_data on line 71: RESULT: Child 1 offset: -1; array: yes
98
[NO_PID]: sqlca: code: 0, state: 00000
99
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
100
[NO_PID]: sqlca: code: 0, state: 00000
101
[NO_PID]: ecpg_get_data on line 71: RESULT: 16 offset: -1; array: yes
102
[NO_PID]: sqlca: code: 0, state: 00000
103
[NO_PID]: ecpg_store_result on line 71: allocating memory for 1 tuples
104
[NO_PID]: sqlca: code: 0, state: 00000
105
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
106
[NO_PID]: sqlca: code: 0, state: 00000
107
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
108
[NO_PID]: sqlca: code: 0, state: 00000
109
[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1
110
[NO_PID]: sqlca: code: 0, state: 00000
111
[NO_PID]: ecpg_execute on line 71: using PQexec
112
[NO_PID]: sqlca: code: 0, state: 00000
113
[NO_PID]: ecpg_execute on line 71: correctly got 1 tuples with 5 fields
114
[NO_PID]: sqlca: code: 0, state: 00000
115
[NO_PID]: ecpg_get_data on line 71: RESULT: Child 2 offset: -1; array: yes
116
[NO_PID]: sqlca: code: 0, state: 00000
117
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
118
[NO_PID]: sqlca: code: 0, state: 00000
119
[NO_PID]: ecpg_get_data on line 71: RESULT: 14 offset: -1; array: yes
120
[NO_PID]: sqlca: code: 0, state: 00000
121
[NO_PID]: ecpg_store_result on line 71: allocating memory for 1 tuples
122
[NO_PID]: sqlca: code: 0, state: 00000
123
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
124
[NO_PID]: sqlca: code: 0, state: 00000
125
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
126
[NO_PID]: sqlca: code: 0, state: 00000
127
[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1
128
[NO_PID]: sqlca: code: 0, state: 00000
129
[NO_PID]: ecpg_execute on line 71: using PQexec
130
[NO_PID]: sqlca: code: 0, state: 00000
131
[NO_PID]: ecpg_execute on line 71: correctly got 1 tuples with 5 fields
132
[NO_PID]: sqlca: code: 0, state: 00000
133
[NO_PID]: ecpg_get_data on line 71: RESULT: Child 3 offset: -1; array: yes
134
[NO_PID]: sqlca: code: 0, state: 00000
135
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
136
[NO_PID]: sqlca: code: 0, state: 00000
137
[NO_PID]: ecpg_get_data on line 71: RESULT: 9 offset: -1; array: yes
138
[NO_PID]: sqlca: code: 0, state: 00000
139
[NO_PID]: ecpg_store_result on line 71: allocating memory for 1 tuples
140
[NO_PID]: sqlca: code: 0, state: 00000
141
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
142
[NO_PID]: sqlca: code: 0, state: 00000
143
[NO_PID]: ecpg_get_data on line 71: RESULT: offset: -1; array: yes
144
[NO_PID]: sqlca: code: 0, state: 00000
145
[NO_PID]: ecpg_execute on line 71: query: fetch cur; with 0 parameter(s) on connection regress1
146
[NO_PID]: sqlca: code: 0, state: 00000
147
[NO_PID]: ecpg_execute on line 71: using PQexec
148
[NO_PID]: sqlca: code: 0, state: 00000
149
[NO_PID]: ecpg_execute on line 71: correctly got 0 tuples with 5 fields
150
[NO_PID]: sqlca: code: 0, state: 00000
151
[NO_PID]: raising sqlcode 100 on line 71: no data found on line 71
152
[NO_PID]: sqlca: code: 100, state: 02000
153
[NO_PID]: ecpg_execute on line 88: query: close cur; with 0 parameter(s) on connection regress1
154
[NO_PID]: sqlca: code: 0, state: 00000
155
[NO_PID]: ecpg_execute on line 88: using PQexec
156
[NO_PID]: sqlca: code: 0, state: 00000
157
[NO_PID]: ecpg_execute on line 88: OK: CLOSE CURSOR
158
[NO_PID]: sqlca: code: 0, state: 00000
159
[NO_PID]: ecpg_execute on line 91: query: drop table family; with 0 parameter(s) on connection regress1
160
[NO_PID]: sqlca: code: 0, state: 00000
161
[NO_PID]: ecpg_execute on line 91: using PQexec
162
[NO_PID]: sqlca: code: 0, state: 00000
163
[NO_PID]: ecpg_execute on line 91: OK: DROP TABLE
164
[NO_PID]: sqlca: code: 0, state: 00000
165
[NO_PID]: ECPGtrans on line 94: action "commit"; connection "regress1"
166
[NO_PID]: sqlca: code: 0, state: 00000
167
[NO_PID]: ecpg_finish: connection regress1 closed
168
[NO_PID]: sqlca: code: 0, state: 00000