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

Back-end problems with Delphi and ODBCExpress

From: Bryan Brunton <bryan(at)flesherfab(dot)com>
To: "'pgsql-interfaces(at)postgresql(dot)org'" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Back-end problems with Delphi and ODBCExpress
Date: 1998-08-12 19:51:33
Message-ID: 316E0AE33DA6D1119E0D00400535C0A301EFBB@zarathustra.flesherfab.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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).


Responses

pgsql-interfaces by date

Next:From: Byron NikolaidisDate: 1998-08-12 20:03:11
Subject: Re: [INTERFACES] Back-end problems with Delphi and ODBCExpress
Previous:From: Tom LaneDate: 1998-08-12 14:48:26
Subject: Re: [INTERFACES] Re: thread-safe libpq and DBD::Pg

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