Re: Select max(id) causes AccessExclusiveLock?

[Stephen Frost <sfrost@xxxxxxxxxxx>]

Edson,

* Edson Richter (edsonrichter@xxxxxxxxxxx) 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

Attachment: signature.asc
Description: Digital signature