Re: Select max(id) causes AccessExclusiveLock?

Edson,

* Edson Richter (edsonrichter@hotmail.com) wrote:
> The programmer added a
>
> LOCK TABLE MyTableName
>
> just before issuing the select max(id) from MyTableName.
>
> I do suspect this is the case, right?

Yup, that'll do it.

http://www.postgresql.org/docs/9.3/static/sql-lock.html

    Thanks,

        Stephen