Is using advisory locks safe with pgxpool?

[ymmt2005]

Hello,

I'm thinking of using the advisory lock feature of PostgreSQL with pgxpool.
https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS

My question is how I can unlock all acquired locks when I put back a connection to the pool.
Does pgxpool call DISCARD ALL so that it resets all session statuses?

[ymmt2005]

Ah, I guess I found the answer.
https://pkg.go.dev/github.com/jackc/pgx/[email protected]/pgxpool#Config

I can use pgpool.Config.AfterRelease to unlock all locks.