On Tue, Aug 22, 2017 at 9:42 AM, Martin Moore <martin.mo...@avbrief.com> wrote:
> Hi, I’m having issues with deadlocks. > > v9.6 on Debian Jessie. > > I have a number of ‘select’ functions which for logging purposes also call > another fn that inserts a record into a ‘logging’ table. > > However, even with only 1 or 2 users making very infrequent calls to the > parent fn, deadlocks are occurring. I’m hoping there’s something I’m > unaware of as this shouldn’t happen! > > What could this be? I don’t have any logs at present as I removed the > insert statement some time ago, but need to get this issue resolved. > > Thanks, > > Martin. > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > *I don't think you will get much help unless you show us the query and the structure* *of the tables involved.* -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.