Parse libpq's "keepalives" option more like other integer options.

tglsfdc · tglsfdc · commit c7a201053e3f · 2024-10-02T17:30:36.000-04:00
Use pqParseIntParam (nee parse_int_param) instead of using strtol directly. This allows trailing whitespace, which the previous coding didn't, and makes the spelling of the error message consistent with other similar cases. This seems to be an oversight in commit e7a2217, which introduced parse_int_param. That fixed places that were using atoi(), but missed this place which was randomly using strtol() instead. Ordinarily I'd consider this minor cleanup not worth back-patching. However, it seems that ecpg assumes it can add trailing whitespace to URL parameters, so that use of the keepalives option fails in that context. Perhaps that's worth improving as a separate matter. In the meantime, back-patch this to all supported branches. Yuto Sasaki (some further cleanup by me) Discussion: https://postgr.es/m/TY2PR01MB36286A7B97B9A15793335D18C1772@TY2PR01MB3628.jpnprd01.prod.outlook.com
diff --git a/src/interfaces/libpq/fe-connect.c b/src/interfaces/libpq/fe-connect.c
@@ -2168,14 +2168,14 @@ connectFailureMessage(PGconn *conn, int errorno)
 static int
 useKeepalives(PGconn *conn)
 {
-	char	   *ep;
 	int			val;
 
 	if (conn->keepalives == NULL)
 		return 1;
-	val = strtol(conn->keepalives, &ep, 10);
-	if (*ep)
+
+	if (!pqParseIntParam(conn->keepalives, &val, conn, "keepalives"))
 		return -1;
+
 	return val != 0 ? 1 : 0;
 }
 
@@ -3083,7 +3083,7 @@ PQconnectPoll(PGconn *conn)
 
 						if (usekeepalives < 0)
 						{
-							libpq_append_conn_error(conn, "keepalives parameter must be an integer");
+							/* error is already reported */
 							err = 1;
 						}
 						else if (usekeepalives == 0)

Original file line number	Diff line number	Diff line change
`@@ -2168,14 +2168,14 @@ connectFailureMessage(PGconn *conn, int errorno)`
`2168`	`2168`	`static int`
`2169`	`2169`	`useKeepalives(PGconn *conn)`
`2170`	`2170`	`{`
`2171`		`- char *ep;`
`2172`	`2171`	`int val;`
`2173`	`2172`
`2174`	`2173`	`if (conn->keepalives == NULL)`
`2175`	`2174`	`return 1;`
`2176`		`- val = strtol(conn->keepalives, &ep, 10);`
`2177`		`- if (*ep)`
	`2175`	`+`
	`2176`	`+ if (!pqParseIntParam(conn->keepalives, &val, conn, "keepalives"))`
`2178`	`2177`	`return -1;`
	`2178`	`+`
`2179`	`2179`	`return val != 0 ? 1 : 0;`
`2180`	`2180`	`}`
`2181`	`2181`
`@@ -3083,7 +3083,7 @@ PQconnectPoll(PGconn *conn)`
`3083`	`3083`
`3084`	`3084`	`if (usekeepalives < 0)`
`3085`	`3085`	`{`
`3086`		`- libpq_append_conn_error(conn, "keepalives parameter must be an integer");`
	`3086`	`+ /* error is already reported */`
`3087`	`3087`	`err = 1;`
`3088`	`3088`	`}`
`3089`	`3089`	`else if (usekeepalives == 0)`