Hello Silvio,
to be honest, I personally do not like seeing DB index names in
the application code.
(Btw. does it work on PG, when the index name is stated uppercase?)
Isn't it possible to use 'SELECT FOR UPDATE' in these cases?
(The other transaction would need to wait till the first one
I'm a little rusty on my Oracle but in PostgreSQL I think this could
be resolved using the Isolation level within the transaction, and
possibly snapshots within the transaction
http://www.postgresql.org/docs/9.2/interactive/sql-set-transaction.html
An other possibility is to request an exclusive