I have written a program where 2 computers are connected to the same
database. The first PC executes an update statement and then sends a
notification. This makes the second PC execute a select statement on the
same table. The second PC then gets an error:
'Field "Fieldname" not found'
I have no trouble executing this same select statement in other places in
the code or from within PgAdmin.
I wonder how this is possible as an update statement does not change
anything to the tablefields. I added a delay (sleep) in the code and then
the problem does not occur, but this is hardly a solution and makes me
question the stability of other code as long as I am not certain why this
occurs.
I am fairly certain this has to do with locking. I assumed that the database
would block the select statement while the table fields are not available.
My hope is that someone can help me as I have searched for a solution for
quite some time, but am no closer to finding it.
Thanks!
The program is written using Delphi 7 and PostgresDac 2.8.0 where I use the
TPSQLQuery to execute the select and update statements and TPSQLNotify for
the notification. My Postgresql version is 9.1.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Postgresql-error-tp5741971.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general