Thread: Back-end problems with Delphi and ODBCExpress

Although I've only found one other person using Delphi, ODBCExpress, and
Postgres, I thought I'd post this just to see if some one can provide
enlightenment:

The source of the problem is setting the Active property on a Dataset
that
is linked to a grid while at the same time doing an update to that table
in a form's
show event.  It appears that the active dataset and the update to the
table exert
some kind of lock on the table.  I can't update or select after that.
In this locked
state, I can't view the table from MS Access or even select the records
from psql
(used from telnet to the database server) even after the Delphi app is
killed. The table
stays in this locked state for what seems to be a random amount of time,
usually
for a very long time forcing the postmaster to be restarted.  I can
however view the
table properties from pgAdmin (the VB app).

Bryan Brunton wrote:

> Although I've only found one other person using Delphi, ODBCExpress, and
> Postgres, I thought I'd post this just to see if some one can provide
> enlightenment:
>
> The source of the problem is setting the Active property on a Dataset
> that
> is linked to a grid while at the same time doing an update to that table
> in a form's
> show event.  It appears that the active dataset and the update to the
> table exert
> some kind of lock on the table.  I can't update or select after that.
> In this locked
> state, I can't view the table from MS Access or even select the records
> from psql
> (used from telnet to the database server) even after the Delphi app is
> killed. The table
> stays in this locked state for what seems to be a random amount of time,
> usually
> for a very long time forcing the postmaster to be restarted.  I can
> however view the
> table properties from pgAdmin (the VB app).

Turn OFF the Driver Option "Use Declare/Fetch" and see if that helps.

Byron