> MargaretGillon@xxxxxxxxxxxxxx wrote: > > Is there a similar command in Postgresql so that the client application > > can find out if there's an unresolved transaction before it starts a new > > one? > > See PQtransactionStatus() in libpq; if you're using a different language > interface, it should provide some means to get the same information. > > http://developer.postgresql.org/docs/postgres/libpq-status.html > > -Neil I am using Visual FoxPro with WINDOWS-ODBC to get to a Postgresql 7.3.4 database on a Redhat9 server. Is there an equilavent command I can use with ODBC? Margaret ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org