Daniel Cristian Cruz <danielcristian@xxxxxxxxx> 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 (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
