search

lbehnke / h2database

Automatically exported from code.google.com/p/h2database
0 stars 0 forks source link

Support "LOCK table IN SHARE ROW EXCLUSIVE MODE" for pgserver/PostgreSQL compatibility mode #58

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
just try to run Drupal against pgserver. During installation, it has an
database test. And it fails when Drupal issue the following statnement:
BEGIN; LOCK drupal_install_test IN SHARE ROW EXCLUSIVE MODE

the database is started with:
jdbc:h2:./data/h2/drupal;MODE=PostgreSQL;MVCC=TRUE

MVCC is set to true to support row level lock.

Postgresql has quite a lot of lock mode, it would be great if H2 could
state which mode it supports in normal H2 and in pgserver
http://www.postgresql.org/docs/8.3/static/explicit-locking.html

Original issue reported on code.google.com by mingfai...@gmail.com on 3 Feb 2009 at 4:32

GoogleCodeExporter commented 9 years ago 
Why do you want to run Drupal against H2?

I have added is to the roadmap, but at the very end. Unless you implement it
yourself, there is little chance it is implemented anytime soon, sorry.

Original comment by thomas.t...@gmail.com on 6 Feb 2009 at 4:39