CRAN warnings and errors, including "Check: whether package can be installed"

[westat-schneider]

I was unable to install the package on Windows with version R 4.4.3, and so I looked at the CRAN check and noticed that there are a few warnings and errors. On Windows, the CRAN checks are showing that the package cannot be installed, matching the issue I'm seeing. Here are the CRAN check results from April 14, 2025.

https://cran.r-project.org/web/checks/check_results_RPostgreSQL.html

Flavor	Version	Tinstall	Tcheck	Ttotal	Status	Flags
r-devel-linux-x86_64-debian-clang	0.7-8	8.85	35.45	44.30	OK
r-devel-linux-x86_64-debian-gcc	0.7-8	6.97	26.65	33.62	OK
r-devel-linux-x86_64-fedora-clang	0.7-8			71.04	OK
r-devel-linux-x86_64-fedora-gcc	0.7-8			69.25	OK
r-devel-windows-x86_64	0.7-8	25.00	109.00	134.00	OK
r-patched-linux-x86_64	0.7-8	9.10	34.92	44.02	OK
r-release-linux-x86_64	0.7-8	8.81	34.45	43.26	OK
r-release-macos-arm64	0.7-8			31.00	WARN
r-release-macos-x86_64	0.7-8			48.00	WARN
r-release-windows-x86_64	0.7-8	18.00	7.00	25.00	ERROR
r-oldrel-macos-arm64	0.7-8			48.00	OK
r-oldrel-macos-x86_64	0.7-8			77.00	OK
r-oldrel-windows-x86_64	0.7-8	18.00	7.00	25.00	ERROR

Check Details

Version: 0.7-8
Check: compiled code
Result: WARN
File ‘RPostgreSQL/libs/RPostgreSQL.so’:
Found ‘___sprintf_chk’, possibly from ‘sprintf’ (C)
Object: ‘libpq/libpq.a’
Found ‘___stderrp’, possibly from ‘stderr’ (C)
Object: ‘libpq/libpq.a’
Found ‘_abort’, possibly from ‘abort’ (C)
Object: ‘libpq/libpq.a’
Found ‘_sprintf’, possibly from ‘sprintf’ (C)
Object: ‘libpq/libpq.a’

Compiled code should not call entry points which might terminate R nor
write to stdout/stderr instead of to the console, nor use Fortran I/O
nor system RNGs nor [v]sprintf.

See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual.
Flavors: r-release-macos-arm64, r-release-macos-x86_64

Version: 0.7-8
Check: whether package can be installed
Result: ERROR
Installation failed.
Flavors: r-release-windows-x86_64, r-oldrel-windows-x86_64