Re: Problem with table lock within a function

Daniel Cristian Cruz <danielcristian(at)gmail(dot)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