Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Back-end problems with Delphi and ODBCExpress

From: Byron Nikolaidis <byronn(at)insightdist(dot)com>
To: Bryan Brunton <bryan(at)flesherfab(dot)com>
Cc: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] Back-end problems with Delphi and ODBCExpress
Date: 1998-08-12 20:03:11
Message-ID: 35D1F4FF.507C87EA@insightdist.com (view raw or flat)
Thread:
Lists: pgsql-interfaces

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


In response to

pgsql-interfaces by date

Next:From: Byron NikolaidisDate: 1998-08-12 21:30:08
Subject: Re: [INTERFACES] Back-end problems with Delphi and ODBCExpress
Previous:From: Bryan BruntonDate: 1998-08-12 19:51:33
Subject: Back-end problems with Delphi and ODBCExpress

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group