sql.notify not available in transaction context

[santicalcagno]

Basically this:

sql.notify('test'); // works
sql.begin(sql => {
  sql.notify('test')  // throws Uncaught TypeError: sql.notify is not a function
}}

Is that expected behavior? I am under the impression that NOTIFY should work in a transaction context as per the docs.

As a workaround I think sql.unsafe works.

Coincidentally, I think the same applies to sql.listen, although I only have a use case for .notifying in transactions.

PS: Thanks for this library! ❤️

[porsager]

Oh that's a good catch. Thank you!

sql.listen won't work cause it's using a dedicated connection for that, but sql.notify should work with the transaction instance as well.

And than you for the kind words ;)