Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitccab6f7

Browse files
committed
Remove int16 from libpgeasy examples. Improve error reporting.
1 parent936ff27 commitccab6f7

File tree

3 files changed

+7
-21
lines changed

3 files changed

+7
-21
lines changed

‎src/interfaces/libpgeasy/examples/pginsert.c

Lines changed: 1 addition & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -18,7 +18,6 @@ main(int argc, char **argv)
1818
floatafloat;
1919
doubleadouble;
2020
charachar[11],
21-
achar16[17],
2221
abpchar[11],
2322
avarchar[51],
2423
atext[51];
@@ -41,7 +40,6 @@ main(int argc, char **argv)
4140
afloat float4, \
4241
adouble float8, \
4342
acharchar, \
44-
achar16char(16), \
4543
abpchar char(10), \
4644
avarchar varchar(50), \
4745
atexttext, \
@@ -58,7 +56,6 @@ main(int argc, char **argv)
5856
'Betty', \
5957
'Charley', \
6058
'Doug', \
61-
'Ernie', \
6259
'now' )",row);
6360
doquery(query);
6461

@@ -73,18 +70,16 @@ main(int argc, char **argv)
7370
&afloat,
7471
&adouble,
7572
achar,
76-
achar16,
7773
abpchar,
7874
avarchar,
7975
atext,
8076
&aabstime)!=END_OF_TUPLES)
81-
printf("int %d\nfloat %f\ndouble %f\nchar %s\nchar16 %s\n\
77+
printf("int %d\nfloat %f\ndouble %f\nchar %s\n\
8278
bpchar %s\nvarchar %s\ntext %s\nabstime %s",
8379
aint,
8480
afloat,
8581
adouble,
8682
achar,
87-
achar16,
8883
abpchar,
8984
avarchar,
9085
atext,

‎src/interfaces/libpgeasy/examples/pgnulltest.c

Lines changed: 4 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,6 @@ main(int argc, char **argv)
2020
floatafloat;
2121
doubleadouble;
2222
charachar[11],
23-
achar16[17],
2423
abpchar[11],
2524
avarchar[51],
2625
atext[51];
@@ -29,7 +28,6 @@ main(int argc, char **argv)
2928
afloat_null,
3029
adouble_null,
3130
achar_null,
32-
achar16_null,
3331
abpchar_null,
3432
avarchar_null,
3533
atext_null,
@@ -52,7 +50,6 @@ main(int argc, char **argv)
5250
afloat float4, \
5351
adouble float8, \
5452
achar char, \
55-
achar16 char(16), \
5653
abpchar char(10), \
5754
avarchar varchar(50), \
5855
atext text, \
@@ -68,8 +65,7 @@ main(int argc, char **argv)
6865
'', \
6966
'', \
7067
'', \
71-
'', \
72-
'');");
68+
CURRENT_TIMESTAMP::abstime);");
7369
#else
7470
sprintf(query,"INSERT INTO testfetch VALUES ( \
7571
NULL, \
@@ -79,7 +75,6 @@ main(int argc, char **argv)
7975
NULL, \
8076
NULL, \
8177
NULL, \
82-
NULL, \
8378
NULL);");
8479
#endif
8580
doquery(query);
@@ -99,8 +94,6 @@ main(int argc, char **argv)
9994
&adouble_null,
10095
achar,
10196
&achar_null,
102-
achar16,
103-
&achar16_null,
10497
abpchar,
10598
&abpchar_null,
10699
avarchar,
@@ -109,30 +102,28 @@ main(int argc, char **argv)
109102
&atext_null,
110103
&aabstime,
111104
&aabstime_null)!=END_OF_TUPLES)
112-
printf("int %d\nfloat %f\ndouble %f\nchar %s\nchar16 %s\n\
105+
printf("int %d\nfloat %f\ndouble %f\nchar %s\n\
113106
bpchar %s\nvarchar %s\ntext %s\nabstime %s\n",
114107
aint,
115108
afloat,
116109
adouble,
117110
achar,
118-
achar16,
119111
abpchar,
120112
avarchar,
121113
atext,
122114
ctime(&aabstime));
123-
printf("NULL:\nint %d\nfloat %d\ndouble %d\nchar %d\nchar16 %d\n\
115+
116+
printf("NULL:\nint %d\nfloat %d\ndouble %d\nchar %d\n\
124117
bpchar %d\nvarchar %d\ntext %d\nabstime %d\n",
125118
aint_null,
126119
afloat_null,
127120
adouble_null,
128121
achar_null,
129-
achar16_null,
130122
abpchar_null,
131123
avarchar_null,
132124
atext_null,
133125
aabstime_null);
134126

135-
136127
doquery("CLOSE c_testfetch");
137128
doquery("COMMIT WORK");
138129
printf("--- %-d rows inserted so far\n",row);

‎src/interfaces/libpgeasy/libpgeasy.c

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -92,11 +92,11 @@ doquery(char *query)
9292
PQresultStatus(res)==PGRES_FATAL_ERROR))
9393
{
9494
if (res!=NULL)
95-
fprintf(stderr,"query error: %s\n",PQcmdStatus(res));
95+
fprintf(stderr,"query error: %s\n",PQresultErrorMessage(res));
9696
else
9797
fprintf(stderr,"connection error: %s\n",PQerrorMessage(conn));
9898
PQfinish(conn);
99-
halt("failedrequest: %s\n",query);
99+
halt("failedquery: %s\n",query);
100100
}
101101
tuple=0;
102102
returnres;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp