Daniel Cristian Cruz <[email protected]> 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
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
