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

[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 Johnson




---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

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

[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  please  don't
> solve it by ripping out trigger support :-)
>
for INSERT OR REPLACE into table ...
if the record was not there, fire the insert trigger
else
   delete the row (fire delete trigger)
   insert the new row (fire the insert trigger)
fi

semantically no other way, I think

Dale.



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[HACKERS] REPLACE INTO table a la mySQL

[Dale Johnson]

I know we're not in the business of copying mySQL,
but the REPLACE INTO table (...) values (...) could be
a useful semantic.  This is a combination INSERT or
UPDATE statement.  For one thing, it is atomic, and
easier to work with at the application level.  Also
if the application doesn'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]