AW: AW: AW: [HACKERS] Getting OID in psql of recent insert

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SEV
Тема AW: AW: AW: [HACKERS] Getting OID in psql of recent insert
Дата
Msg-id 219F68D65015D011A8E000006F8590C603FDC18B@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Ответы RE: AW: AW: [HACKERS] Getting OID in psql of recent insert  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Zeugswetter Andreas SEV
Дата:
Сообщение: AW: [HACKERS] Re: SQL statements: begin and end
Следующее
От: Vince Vielhaber
Дата:
Сообщение: RE: AW: [HACKERS] SQL statements: begin and end