`ConnectionError` - Session terminated by database without notifying the library

[linhub15]

Using a cloud managed DB often terminates sessions without notifying the library. This causes ConnectionError because the library was not notified of the cancelled connection.

There is a TODO comment mentioned that this will be fixed.

... will be removed once we move to async handling of messages by the frontend ...
https://github.com/denodrivers/postgres/blob/main/connection/connection.ts#L167-L171

Is there a workaround in the meantime?

[linhub15]

Would it be wrong to recursively call Connection.query(...)?

postgres/connection/connection.ts

Lines 953 to 959 in 8a07131

	} catch (e) {
	if (e instanceof ConnectionError) {
	await this.end();
	}
	throw e;
	} finally {
	this.#queryLock.push(undefined);

} catch (e) { 
   if (e instanceof ConnectionError) { 
     await this.end();
+    return await this.query(query);
   } 
   throw e;
 } finally {
   this.#queryLock.push(undefined);