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 35: query: set datestyle to mdy; with 0 parameter(s) on connection regress1
6
[NO_PID]: sqlca: code: 0, state: 00000
7
[NO_PID]: ecpg_execute on line 35: using PQexec
8
[NO_PID]: sqlca: code: 0, state: 00000
9
[NO_PID]: ecpg_execute on line 35: OK: SET
10
[NO_PID]: sqlca: code: 0, state: 00000
11
[NO_PID]: ecpg_execute on line 37: query: create table test ( a serial , b numeric ( 12 , 3 ) , c varchar , d varchar ( 3 ) , e char ( 4 ) , f timestamptz , g boolean , h box , i inet ); with 0 parameter(s) on connection regress1
12
[NO_PID]: sqlca: code: 0, state: 00000
13
[NO_PID]: ecpg_execute on line 37: using PQexec
14
[NO_PID]: sqlca: code: 0, state: 00000
15
[NO_PID]: ecpg_execute on line 37: OK: CREATE TABLE
16
[NO_PID]: sqlca: code: 0, state: 00000
17
[NO_PID]: ecpg_execute on line 38: query: insert into test ( b , c , d , e , f , g , h , i ) values ( 23.456 , 'varchar' , 'v' , 'c' , '2003-03-03 12:33:07 PDT' , true , '(1,2,3,4)' , '2001:4f8:3:ba:2e0:81ff:fe22:d1f1/128' ); with 0 parameter(s) on connection regress1
18
[NO_PID]: sqlca: code: 0, state: 00000
19
[NO_PID]: ecpg_execute on line 38: using PQexec
20
[NO_PID]: sqlca: code: 0, state: 00000
21
[NO_PID]: ecpg_execute on line 38: OK: INSERT 0 1
22
[NO_PID]: sqlca: code: 0, state: 00000
23
[NO_PID]: ecpg_execute on line 39: query: insert into test ( b , c , d , e , f , g , h , i ) values ( 2.446456 , null , 'v' , 'c' , '2003-03-03 12:33:07 PDT' , false , null , null ); with 0 parameter(s) on connection regress1
24
[NO_PID]: sqlca: code: 0, state: 00000
25
[NO_PID]: ecpg_execute on line 39: using PQexec
26
[NO_PID]: sqlca: code: 0, state: 00000
27
[NO_PID]: ecpg_execute on line 39: OK: INSERT 0 1
28
[NO_PID]: sqlca: code: 0, state: 00000
29
[NO_PID]: ecpg_execute on line 42: query: select a , b , c , d , e , f , g , h , i from test order by a; with 0 parameter(s) on connection regress1
30
[NO_PID]: sqlca: code: 0, state: 00000
31
[NO_PID]: ecpg_execute on line 42: using PQexec
32
[NO_PID]: sqlca: code: 0, state: 00000
33
[NO_PID]: ecpg_execute on line 42: correctly got 2 tuples with 9 fields
34
[NO_PID]: sqlca: code: 0, state: 00000
35
[NO_PID]: ecpg_execute on line 42: putting result (2 tuples) into descriptor mydesc
36
[NO_PID]: sqlca: code: 0, state: 00000
37
[NO_PID]: ECPGget_desc: reading items for tuple 1
38
[NO_PID]: sqlca: code: 0, state: 00000
39
[NO_PID]: ecpg_store_result on line 43: allocating memory for 2 tuples
40
[NO_PID]: sqlca: code: 0, state: 00000
41
[NO_PID]: ecpg_get_data on line 43: RESULT: 1 offset: -1; array: no
42
[NO_PID]: sqlca: code: 0, state: 00000
43
[NO_PID]: ecpg_get_data on line 43: RESULT: 2 offset: -1; array: no
44
[NO_PID]: sqlca: code: 0, state: 00000
45
[NO_PID]: ECPGget_desc: reading items for tuple 2
46
[NO_PID]: sqlca: code: 0, state: 00000
47
[NO_PID]: ecpg_store_result on line 44: allocating memory for 2 tuples
48
[NO_PID]: sqlca: code: 0, state: 00000
49
[NO_PID]: ecpg_get_data on line 44: RESULT: 23.456 offset: -1; array: no
50
[NO_PID]: sqlca: code: 0, state: 00000
51
[NO_PID]: ecpg_get_data on line 44: RESULT: 2.446 offset: -1; array: no
52
[NO_PID]: sqlca: code: 0, state: 00000
53
[NO_PID]: ECPGget_desc: reading items for tuple 3
54
[NO_PID]: sqlca: code: 0, state: 00000
55
[NO_PID]: ecpg_store_result on line 45: allocating memory for 2 tuples
56
[NO_PID]: sqlca: code: 0, state: 00000
57
[NO_PID]: ecpg_get_data on line 45: RESULT: varchar offset: -1; array: no
58
[NO_PID]: sqlca: code: 0, state: 00000
59
[NO_PID]: ecpg_get_data on line 45: RESULT: offset: -1; array: no
60
[NO_PID]: sqlca: code: 0, state: 00000
61
[NO_PID]: ECPGget_desc: reading items for tuple 4
62
[NO_PID]: sqlca: code: 0, state: 00000
63
[NO_PID]: ecpg_store_result on line 46: allocating memory for 2 tuples
64
[NO_PID]: sqlca: code: 0, state: 00000
65
[NO_PID]: ecpg_get_data on line 46: RESULT: v offset: -1; array: no
66
[NO_PID]: sqlca: code: 0, state: 00000
67
[NO_PID]: ecpg_get_data on line 46: RESULT: v offset: -1; array: no
68
[NO_PID]: sqlca: code: 0, state: 00000
69
[NO_PID]: ECPGget_desc: reading items for tuple 5
70
[NO_PID]: sqlca: code: 0, state: 00000
71
[NO_PID]: ecpg_store_result on line 47: allocating memory for 2 tuples
72
[NO_PID]: sqlca: code: 0, state: 00000
73
[NO_PID]: ecpg_get_data on line 47: RESULT: c offset: -1; array: no
74
[NO_PID]: sqlca: code: 0, state: 00000
75
[NO_PID]: ecpg_get_data on line 47: RESULT: c offset: -1; array: no
76
[NO_PID]: sqlca: code: 0, state: 00000
77
[NO_PID]: ECPGget_desc: reading items for tuple 6
78
[NO_PID]: sqlca: code: 0, state: 00000
79
[NO_PID]: ecpg_store_result on line 48: allocating memory for 2 tuples
80
[NO_PID]: sqlca: code: 0, state: 00000
81
[NO_PID]: ecpg_get_data on line 48: RESULT: Mon Mar 03 11:33:07 2003 PST offset: -1; array: no
82
[NO_PID]: sqlca: code: 0, state: 00000
83
[NO_PID]: ecpg_get_data on line 48: RESULT: Mon Mar 03 11:33:07 2003 PST offset: -1; array: no
84
[NO_PID]: sqlca: code: 0, state: 00000
85
[NO_PID]: ECPGget_desc: reading items for tuple 7
86
[NO_PID]: sqlca: code: 0, state: 00000
87
[NO_PID]: ecpg_store_result on line 49: allocating memory for 2 tuples
88
[NO_PID]: sqlca: code: 0, state: 00000
89
[NO_PID]: ecpg_get_data on line 49: RESULT: t offset: -1; array: no
90
[NO_PID]: sqlca: code: 0, state: 00000
91
[NO_PID]: ecpg_get_data on line 49: RESULT: f offset: -1; array: no
92
[NO_PID]: sqlca: code: 0, state: 00000
93
[NO_PID]: ECPGget_desc: reading items for tuple 9
94
[NO_PID]: sqlca: code: 0, state: 00000
95
[NO_PID]: ecpg_store_result on line 52: allocating memory for 2 tuples
96
[NO_PID]: sqlca: code: 0, state: 00000
97
[NO_PID]: ecpg_get_data on line 52: RESULT: 2001:4f8:3:ba:2e0:81ff:fe22:d1f1 offset: -1; array: no
98
[NO_PID]: sqlca: code: 0, state: 00000
99
[NO_PID]: ecpg_get_data on line 52: RESULT: offset: -1; array: no
100
[NO_PID]: sqlca: code: 0, state: 00000
101
[NO_PID]: ecpg_finish: connection regress1 closed
102
[NO_PID]: sqlca: code: 0, state: 00000