Hello all,
Is there any way to ensure that one query has completed before a
second one is executed? I have to execute an UPDATE and follow it
immediately with a SELECT, but I find that the SELECT is picking up
incorrect data because - I assume - the UPDATE hasn't completed yet.
When I re-run the SELECT a few seconds later I gvet the correct data.
I'm accessing PostgresSQL via ADO on a windows machine, and I tried -
(i) enclosing the two queries in one transaction, as follows:
begin;
update ... (etc)... ;
select ...(etc)...;
commit;
(ii) putting a COMMIT before the SELECT, as follows:
begin;
update ... (etc)... ;
commit;
select ...(etc)...;
Neither produces what I want. Any help will be greatly appreciated!
--Ray.
-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
rod@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------