zlacker
[parent]
[thread]
1 comments
1. dikei+(OP)
[view]
[source]
2023-09-25 02:44:40
IIRC, LISTEN/NOTIFY needs to pin a PostgreSQL connection to the client, so you won't be able to use transaction-level pooling with it.
replies(1):
>>rockwo+8
◧
2. rockwo+8
[view]
[source]
2023-09-25 02:45:42
>>dikei+(OP)
I used a separate dedicated connection for listen that wasn’t in the pool. Notify is fine to be apart of a normal txn
[go to top]