Ok, the matter is i'm using ADO Connection to acces my database. The ADO Object has several methods, like BeginTrans, RollBackTrans, CommitTrans, etc.
When I issue "select count(*)as conteo from pg_locks where mode='Exclusive Lock' ", it doesn't return any record.
I've also tried with 'ExclusiveRowLo cks' and it doesn't work.
Thank you....
ElProta
Last Activity: Oct 22 '07, 06:10 PM
Joined: Oct 11 '07
Location:
-
But, does anyone know the command i have to issue to get uncommited transactions ?
That's what i wanna know.
Thank you so much....Leave a comment:
-
Transactions
Hi people. I'm connecting to a PostreSql database trough ADO. Sometimes I issue the command to begin a transaction, and it works perfectly. But, i want to rollback a transaction, looking for it in a table.
For example, in SQL Server i used to issue "select @@trancount", but how can i get all active transactions in Postgres.
Thanks.
No activity results to display
Leave a comment: