AW: AW: AW: [HACKERS] Getting OID in psql of recent insert - Mailing list pgsql-hackers

From Zeugswetter Andreas SEV
Subject AW: AW: AW: [HACKERS] Getting OID in psql of recent insert
Date
Msg-id 219F68D65015D011A8E000006F8590C603FDC18B@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses RE: AW: AW: [HACKERS] Getting OID in psql of recent insert  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-hackers
> They get the location they ask for, or a failure.  Hunting around for
> the new tuple seems like a real waste, and if someone vacuums, it is
> gone, no?

It is probably worse, since they might even get the wrong row, 
but that's the same in Informix and Oracle.

In Informix:

a: selects rowid
b: updates row, row grows, does not fit in page, is relocated
c: inserts rows, pysical location of rowid is reused
a: selects row by rowid, gets differet row --> bummer

Andreas


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SEV
Date:
Subject: AW: [HACKERS] Re: SQL statements: begin and end
Next
From: Vince Vielhaber
Date:
Subject: RE: AW: [HACKERS] SQL statements: begin and end