use await with pgPromise connections sometimes produces unexpected bahvious

[jonseymour]

Problem Statement

I am getting unexpected behaviour when attempting to use a pg-promise connection with an await statement and I don't understand why.

The connection is allocated ok, but an attempt to call query() on returned connection fails without returning a result or throwing an error.. AFAICT the thread of control never returns to the invoking function.

Can anyone explain what is going on?

update: eventually narrowed it down to a faulty connection string

url=postgres://pguser:foobar@dbhost:5432/non-existent-database

Once I corrected the database name in the connection string, everything worked as expected.

However, that doesn't explain why the pgp call worked, but the subsequent calls failed without trace with emphasis on the words without trace

Expected behaviour

output as either:

obtained db
have result
<program exits>

or

obtained db
have error
<program exits>

Actual behavior

obtained db
<program exits>

Steps to reproduce

  import { IMain } from 'pg-promise'
  import * as pgPromise from 'pg-promise'
  
  const pgp: IMain = pgPromise({
    //  query: (e) => { console.log(e) }, //print every query
    capSQL: true // generate capitalized SQL
  })
  import * as pgPromise from 'pg-promise'
  const db = pgp(`postgres://${connectionString}`)
  console.log("obtained db")
  try {
    const res = await db.query("select 1");
    console.log("have result")        
  } catch (e) {
    console.log("have error")
  }

Environment

• Version of pg-promise: 8.7.3
• OS type (Linux/Windows/Mac): OSX
• Version of Node.js: v18.0.0

[jonseymour]

Ok, upgrading to 10.11.1 fixes this - I now get an error message as expected.