From: Byron Nikolaidis <byronn@insightdist.com>
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
Date: Wed, 12 Aug 1998 16:03:11 -0400
Message-ID: <35D1F4FF.507C87EA@insightdist.com> (raw)
References: <316E0AE33DA6D1119E0D00400535C0A301EFBB@zarathustra.flesherfab.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, bryan@flesherfab.com
Subject: Re: [INTERFACES] Back-end problems with Delphi and ODBCExpress
In-Reply-To: <35D1F4FF.507C87EA@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox