Message-Id: <35D1F4FF.507C87EA@insightdist.com>
Date: Wed, 12 Aug 1998 16:03:11 -0400
From: Byron Nikolaidis <byronn@insightdist.com>
Mime-Version: 1.0
To: Bryan Brunton <bryan@flesherfab.com>
Cc: "'pgsql-interfaces@postgresql.org'" <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Back-end problems with Delphi and ODBCExpress
References: 
 <316E0AE33DA6D1119E0D00400535C0A301EFBB@zarathustra.flesherfab.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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