[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 this timebomb. Dale

[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 MUCH better. And

[HACKERS] REPLACE INTO table a la mySQL

2001-06-05 Thread Dale Johnson
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]