Hello:
Hello Carlos.
I continue to work in the implementation of the 3.0 protocol in C#, i'm making a test that consist on:
- Create a database. - Create a table in the new database. - Start transaction. - Insert 100 rows of data in the new table. - Commit transaction.
For start a transaction i send a Query message with this as statement text:
START TRANSACTION ISOLATION LEVEL READ COMMITTED
For commit a transaction i send a Query message with this as statement text:
COMMIT TRANSACTION
For execute the inserts i use parametrized commands with Extended query mode, sending this sequence of messages:
- Parse & Flush ( Only for the first command ) - Describe & Flush ( Only for the first command ) - Close Portal ( begining at second command ) - Bind & Flush - Execute & Sync
But the Sync message seems to be commiting the transaction, if i send a Flush message all works as expected with inserts, but create database & table will not work.
Sorry for late response...
I could finally get Npgsql to talk protocol 3.0 version :) It is not 100% but it is near...
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 hope it helps.
-- Regards,
Francisco Figueiredo Jr.
------ "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
