Preventing selection of data during transaction

From: Henrik <henke(at)mac(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Preventing selection of data during transaction
Date: 2007-09-28 13:41:15
Message-ID: 34E88A13-1011-4D11-ABF2-FF08CAC42DCC@mac.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello List,

I wonder if it is possible to make data selected in one query NOT
accessible for a SELECT in another query?

The thing is that I have a cleaning script that selects some rows
from a table and processes them.
During that processing I don't want these rows to end up in another
result set. But I also don't want the other result set to wait until
my cleaning transaction is done, I just want it to ignore it.

Is this possible in the database level or do I need to take care of
it on the application level?

Regards,
Henke

Browse pgsql-general by date

  From Date Subject
Next Message John Smith 2007-09-28 14:07:23 Re: access privileges: grant select on (all current and future tables)?
Previous Message Owen Hartnett 2007-09-28 13:33:48 Request for feature: pg_dump schema masquerade flag