Re: Additional Notes

2023-11-16 Thread Tom Lane
Daniel Rinehart writes: > Our callout use of NOTIFY within a TRIGGER may be tangential to the root > cause. What we wanted to call out is that neither the NOTIFY page or the > https://www.postgresql.org/docs/16/explicit-locking.html page mention that > NOTIFY uses an AccessExclusiveLock. Like Lau

Re: Additional Notes

2023-11-16 Thread Daniel Rinehart
Our callout use of NOTIFY within a TRIGGER may be tangential to the root cause. What we wanted to call out is that neither the NOTIFY page or the https://www.postgresql.org/docs/16/explicit-locking.html page mention that NOTIFY uses an AccessExclusiveLock. -- Daniel R. [http://danielr.neophi.com/