Re: OID order = INSERT order?
От
elein
Тема
Re: OID order = INSERT order?
Дата
Msg-id
200209232059.g8NKxZI5299618@pimout2-ext.prodigy.net
Ответ на
Re: OID order = INSERT order? (scott.marlowe)
Список
Дерево обсуждения
OID order = INSERT order? Justin Hawkins <justin@internode.com.au>
Re: OID order = INSERT order? Martijn van Oosterhout <kleptog@svana.org>
Re: OID order = INSERT order? Tom Lane <tgl@sss.pgh.pa.us>
Re: OID order = INSERT order? "scott.marlowe" <scott.marlowe@ihs.com>
Re: OID order = INSERT order? elein <elein@norcov.com>
Re: OID order = INSERT order? Tom Lane <tgl@sss.pgh.pa.us>
Re: OID order = INSERT order? Elaine Lindelef <eel@cognitivity.com>
Re: OID order = INSERT order? Roland Roberts <roland@astrofoto.org>
Re: OID order = INSERT order? Adrian von Bidder <avbidder@fortytwo.ch>
In 7.3b1, the oids of a row do not change on update according to my experiment. I had thought they did. Is this new with 7.3? elein elein@norcov.com On Monday 16 September 2002 08:43, scott.marlowe wrote: > On 13 Sep 2002, Justin Hawkins wrote: > > Hi folks, > > > > I am converting a legacy (DBM file backend) app to SQL. The current > > storage scheme utlizes ordered list values on objects. To emulate this > > I'm just doing multiple INSERTs on a table. > > > > I need to make sure they will come back out in the same order, every > > time though. > > > > When I fetch values back from the table, if I 'ORDER BY oid', will I > > always get them back in the same order I put them in? > > If you update a row, it will then have a different OID since postgresql > uses MVCC. > > do it the right way, make a sequence and attach it to the table. > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
В списке pgsql-general по дате отправления
