Features that sooner or later will be added to ngx_postgres
:
Add support for SSL connections to the database.
Add support for dropping of idle keep-alived connections to the database.
Add
$postgres_error
variable.Add support for sending mulitple queries in one go (transactions, multiple SELECTs, etc), this will require changes in the processing flow and RDS format.
Add
postgres_escape_bytea
orpostgres_escape_binary
.Use
PQescapeStringConn()
instead ofPQescapeString()
, this will require lazy-evaluation of the variables after we acquire connection, but before we send query to the database. Notes: Don't break$postgres_query
.Cancel long-running queries using
PQcancel()
.Detect server version using
PQserverVersion()
.