Force Lock - Mailing list pgsql-novice

Hello all,

Is there a way I can force a more aggressive lock on a table in a SELECT statement that’s being executed in a transaction?

SELECT FOR UPDATE is not aggressive enough. I need an exclusive lock on that particular table the select is accessing.

I cant seem to figure out how to get this working.

Thanks,

Girish