Re: [GENERAL] Select max(id) causes AccessExclusiveLock?

[Stephen Frost]

Edson,

* Edson Richter (edsonrich...@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

signature.asc
Description: Digital signature