libpg is the C client library to access a Postgres database
Questions tagged [libpg]
5 questions
1
vote
1 answer
What is the purpose of the PostgreSQL function pg_ping()?
According to the manual ( https://php.net/pg_ping ):
pg_ping() pings a database connection and tries to reconnect it if it is broken.
Aaaalright... So where would one ever do that? Is this for many-hours-long while (1) loops which only very rarely…
user11555230
1
vote
3 answers
Pass multiple postgres SQL statements in a single PGexec call
In t-sql, it's possible to run multiple select statements without a ;. Example:
select 1 select 2 is valid, and returns two datasets of 1 and 2 respectively.
In postgres, it is not possible to run multiple select statements... you need a ; delimiter…
skilbjo
- 510
- 1
- 7
- 20
0
votes
1 answer
Postgres Date Type Value
Want to retrieve a date type from a postgres table using liqpq PQexecParams() in binary mode (please humor me).
https://www.postgresql.org/docs/14/datatype-datetime.html says that a date is 4 bytes (4713 BC to 5874897 AD).
src/include/utils/date.h…
myk
- 708
- 2
- 8
- 20
0
votes
1 answer
How to detect deadlocks in PostgreSQL when using PHP's pg_* functions?
I use transactions with PostgreSQL. Transactions are a necessary part of serious databasing. Transactions inevitably lead to "deadlocks". Deadlocks are logged as errors, as they are. I don't want to ever have any errors logged, so I need to handle…
Island Crumley
- 65
- 4
0
votes
0 answers
Google-Play rejection due to libpng security vulnerabilities
I have an Eclipse project. When i exported the APK it worked perfectly, but when I publish it on google play it gave me this error:
Libpng library
The vulnerabilities were fixed in libpng v1.0.66, v.1.2.56, v.1.4.19,
v1.5.26 or higher. You can…
speedox
- 1