[HACKERS] Re: AW: Re: OID wraparound: summary and proposal

2001-08-27 Thread Dale Johnson
> > > The way I see it there are 4 options for the OID: > What about a vacuum analyze for the database that renumbers theOIDs back at some baseline? There is still a limitation on the total number of active rows in the database (0.5 * 2^32), but at least we wouldn't have thi

[HACKERS] Re: Re: REPLACE INTO table a la mySQL

2001-06-11 Thread Dale Johnson
"Jan Wieck" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > mlw wrote: > > [...] > > REPLACE into table set xx=yy, ww = zz where ID = fubar; > > > > A MUCH better solution! > > Please solve the trigger problem at least theoretical before > claiming that mySQL is that MUC

[HACKERS] REPLACE INTO table a la mySQL

2001-06-05 Thread Dale Johnson
x27;t care about previous values, then execution has fewer locking issues and race conditions. comments? Dale Johnson ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]