I have a testprogram (using libpq) reading data from a cursor and large objects 
according to the result of the cursor. The cursor is opened in a serializable 
transaction.

Just for test reasons I know tried the following:
I started the test program that reads the data from the cursor and that reads the 
large objects according to the result of the fetch. While the test was running I now 
was dropping all large objects in a parallel session. Since I am using a serializable 
transaction in the test program I still should be able to read all the large objects, 
even if I drop them in a parallel session. But it does not work. I get an error, that 
the large object can't be opened.

I now tried the same with with two simple psql sessions. Here it works the way I 
expected it to.

Has anybody an explanation for that? Is it due to the libpq functions lo_open ...?

Thanks
Andreas
______________________________________________________________________________
Erster Klick - SMS versenden, zweiter Klick - die Telefonnummer im 
Adressbuch speichern bei: http://freemail.web.de/features/?mc=021151


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to