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