UpdateableResultSets and concurrency.

From: Ola Sundell <ola(at)miranda(dot)org>
To: "'PostgreSQL jdbc list'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: UpdateableResultSets and concurrency.
Date: 2001-07-08 22:19:21
Message-ID: Pine.LNX.4.21.0106271555440.26183-100000@miranda.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc pgsql-patches

On Tue, 26 Jun 2001, Dave Cramer wrote:

> Ola,
>
> How are you planning on determining if the underlying data has been
> changed by some other process? There is a system column called xmin
> which can be used, however you will have to add it to the select.
>
> Dave

At first, I will let the backend handle any and all problems that might
occur. I will simply forward any exceptions I get, and let the overlying
code handle the problems. I checked the MySQL driver, and that is how they
are doing it.

I wonder how it works with non-free databases. Does anyone here know?

Ola

--
Ola Sundell
ola(at)miranda(dot)org - olas(at)wiw(dot)org - ola(dot)sundell(at)upright(dot)se
http://miranda.org/~ola

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ola Sundell 2001-07-09 07:48:43 Re: UpdateableResultSets and concurrency.
Previous Message priya subramaniam 2001-07-08 06:04:42 Is it possible to rename the db?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Eisentraut 2001-07-08 22:55:37 To do list for DatabaseMetaData
Previous Message Bruce Momjian 2001-07-08 21:50:31 Re: DatabaseMetaData.getCatalogs()

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-07-09 01:31:04 Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword
Previous Message Peter Eisentraut 2001-07-08 22:15:31 Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword