| @@ -0,0 +1,11 @@
+--- src/pgsql_plugin.c 2006-08-28 22:28:02.000000000 +0300
++++ src/pgsql_plugin.c.new 2006-08-28 22:28:22.000000000 +0300
+@@ -519,7 +519,7 @@
+
+ /* "LOCK ..." stuff */
+ if (config.sql_dont_try_update) snprintf(lock_clause, sizeof(lock_clause), "BEGIN;");
+- else snprintf(lock_clause, sizeof(lock_clause), "BEGIN; LOCK %s IN EXCLUSIVE MODE;", config.sql_table);
++ else snprintf(lock_clause, sizeof(lock_clause), "BEGIN; LOCK %s IN ROW EXCLUSIVE MODE;", config.sql_table);
+
+ /* "UPDATE ... SET ..." stuff */
+ snprintf(update_clause, sizeof(update_clause), "UPDATE %s ", config.sql_table);
|
