Re: Problem with table lock within a function

Daniel Cristian Cruz <danielcristian@gmail.com> writes:
> sgn=# SELECT * FROM pg_locks WHERE relation = 1706665;
>  locktype | database | relation | page | tuple | transactionid | classid |
> objid | objsubid | transaction |  pid  |        mode         | granted
>
----------+----------+----------+------+-------+---------------+---------+-------+----------+-------------+-------+---------------------+---------
>  relation |  1705022 |  1706665 |      |       |               |
> |       |          |   160721874 | 25743 | AccessExclusiveLock | f

> What could be wrong? How could I get an access share lock only using select?

Whatever is trying to take that AccessExclusiveLock is most certainly
not "only using select".  Have you looked into pg_stat_activity to
try to see what it *is* doing?

            regards, tom lane