[Pgpool-general] About insert_lock = true
Lazaro Rubén García Martinez
lgarciam at vnz.uci.cu
Sun Jun 5 21:48:51 UTC 2011
Hello every one in the list, I have a question related with insert_lock property. In the documentation says that if insert_lock is set to true pgpool-II automatically adds the next queries each time an INSERT is executed:
BEGIN;
LOCK TABLE ...
INSERT INTO ...
COMMIT;
But in postgresql logs file, I don't see a lock table statement. The logs writing in postgresql logs file are:
2011-06-05 16:59:16 VET [18284]: [3-1] LOG: statement: BEGIN
2011-06-05 16:59:16 VET [18284]: [4-1] LOG: duration: 0.162 ms
2011-06-05 16:59:16 VET [18284]: [5-1] LOG: statement: SELECT 1 FROM prueba_id_seq FOR UPDATE
2011-06-05 16:59:16 VET [18284]: [6-1] LOG: duration: 0.771 ms
2011-06-05 16:59:16 VET [18284]: [7-1] LOG: statement: INSERT INTO prueba(nombre) VALUES('Ire');
2011-06-05 16:59:16 VET [18284]: [8-1] LOG: duration: 0.681 ms
2011-06-05 16:59:16 VET [18284]: [9-1] LOG: statement: COMMIT
This is an expected behavior?? I'm using pgpool-3.0.4 with postgresql 8.3.14
Thank you very much for your time.
Regards.
More information about the Pgpool-general
mailing list