Error: client.ref is not a function

[ellagwithington]

Hello,
We use pg in our project, which has a pg-pool dependency such that every time we build a new docker container, it gets the latest version of pg-pool. This afternoon, when running a new container, it appears that the addition of the ref method in "Allow Node to exit if the pool is idle (#2568)" seems to be causing the project to fail with no changes to our code. In cloud run I get this error:

node-postgres/packages/pg-pool/index.js

Line 140 in 684cd09

client.ref()

There is no way to default to an earlier version of pg-pool within the project, so I was hoping I could get some help fixing this issue.
Thank You!

[brianc]

yeah...sorry about that

#2582
#2583

should have a fix out in a few min

[fluggo]

@brianc Didn't the pg-pool package depend on the version of pg with the ref/unref methods added?

[brianc]

@fluggo kinda - pg-pool doesn't depend on pg, pg depends on pg-pool (i know...) and pg's dep allows semver minor floating. So if you have an old version of pg installed at exactly 8.6 it'll install the latest semver minor pg-pool which requires client.ref to exist. Kinda weird peer dependency issue. Publishing a new semver patch of pg-pool will make it work w/ older versions of node-postgres.

[ellagwithington]

Thanks!

[brianc]

thank you for your patience! Takes a bit to push a patch because i wait for tests to run

[brianc]

k released new semver patch of pg-pool which should work with much older versions of pg - sorry about that!