set lock mode

diff --git a/gen/passwd.dc b/gen/passwd.dc
index 835f61bf3166103debc784f6c05c004295b76f7d..3c4bbad83f576db89da1cd2ce49a7cbabb0cc1b5 100644 (file)
--- a/gen/passwd.dc
+++ b/gen/passwd.dc
@@ -36,6 +36,7 @@ char **argv;
 
 #ifsql INGRES
     EXEC SQL CONNECT moira;
+    EXEC SQL SET LOCKMODE SESSION WHERE LEVEL=TABLE, READLOCK=SHARED;
 #endsql
 #ifsql INFORMIX
     EXEC SQL DATABASE moira;

diff --git a/gen/prlogger.dc b/gen/prlogger.dc
index 6c616c260568dd5c4a5203970ec0fd277dc03d50..4afb2a44b2410b062f405cc00d51679b07a401a8 100644 (file)
--- a/gen/prlogger.dc
+++ b/gen/prlogger.dc
@@ -34,6 +34,7 @@ char **argv;
 
 #ifsql INGRES
     EXEC SQL CONNECT moira;
+    EXEC SQL SET LOCKMODE SESSION WHERE LEVEL=TABLE, READLOCK=SHARED;
 #endsql
 #ifsql INFORMIX
     EXEC SQL DATABASE moira;