> "Dave Cramer" <[EMAIL PROTECTED]> writes:
> > Can the version # of
> > the row be made available to the client?
>
> There is no "version # of the row" in postgres, unless you
> set up such a
> thing for yourself (which could certainly be done, using triggers).
And in addition there is no row
On Fri, Jun 15, 2001 at 10:21:37AM -0400, Tom Lane wrote:
> "Dave Cramer" <[EMAIL PROTECTED]> writes:
> > I had no idea that xmin even existed, but having a quick look I think this
> > is what I am looking for. Can I assume that if xmin has changed, then
> > another process has changed the underly
"Dave Cramer" <[EMAIL PROTECTED]> writes:
> Can the version # of
> the row be made available to the client?
There is no "version # of the row" in postgres, unless you set up such a
thing for yourself (which could certainly be done, using triggers).
regards, tom lane
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Dave Cramer" <[EMAIL PROTECTED]>
Cc: "Henshall, Stuart - WCP" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 10:21 AM
Subject: Re: [HACKERS] RE: Row Versi
"Dave Cramer" <[EMAIL PROTECTED]> writes:
> I had no idea that xmin even existed, but having a quick look I think this
> is what I am looking for. Can I assume that if xmin has changed, then
> another process has changed the underlying data ?
xmin is a transaction ID, not a process ID, but lookin
ROTECTED]>
To: "'Dave Cramer'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 5:41 AM
Subject: [HACKERS] RE: Row Versioning, for jdbc updateable result sets
> Don't know about JDBC, but couldn't you just use UPDATE SET
> = WHE
Don't know about JDBC, but couldn't you just use UPDATE SET
= WHERE xmin= AND primarykey= and
get the number of altered records? (if its zero then you know somethings
wrong and can investigate further)
- Stuart
> -Original Message-
> From: Dave Cramer [SMTP:[EMAIL PROTECTED]]
> Sent: Thu
