Sorry for late response...
I could finally get Npgsql to talk protocol 3.0 version :) It is not 100% but it is near...
Great !! I'm going to open my code at sourceforge :)
I give it a try in a test similar to yours... I didn't send the create database commands just the row insertion.
in both sequences, I could get the desired behaviour.
I could send the begin transaction in simple query mode, send the insert in extended mode and send a commit or rollback in simple mode sending the sync message in the end of extended mode.
Are you still having problems with it?
I have it fixed sending the Sync message only for ALTER, CREATE AND DROP commands and seems to work as expected, iwill try to do more tests with transactions and the sync message soon,
-- Best regards
Carlos Guzmán Álvarez Vigo-Spain
- Miembro del Proyecto FirebirdSQL. - Miembro honorario de la Fundación FirebirdSQL.
http://www.firebirdsql.org
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend