| From: | MargaretGillon(at)chromalloy(dot)com |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to know if a TRANSACTION isn't completed |
| Date: | 2005-07-01 16:04:27 |
| Message-ID: | OF40FA886E.DB8AFADD-ON88257031.0057BE92-88257031.00571335@CHROMALLOY.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> MargaretGillon(at)chromalloy(dot)com 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2005-07-01 16:08:46 | Re: Hot to restrict access to subset of data |
| Previous Message | Gregory Youngblood | 2005-07-01 15:13:00 | Re: Hot to restrict access to subset of data |