Re: heap_create with OID? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: heap_create with OID?
Date
Msg-id 200007041614.MAA26877@candle.pha.pa.us
Whole thread Raw
In response to Re: heap_create with OID?  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
> Updating OIDs sounds like a *very* scary thing to do. My motivation for
> heap_create_oid is very specific - I want to be able to do a valid database
> backup/restore, and need to handle the current (bad) BLOB implementation. I
> would sincerely hope that (a) heap_create_oid would be marked in some way
> as 'internal use only', and (b) go away in 7.2 or 7.3 when TOASTED BLOBs
> come along...

If you accidentally delete a row with a specific oid, how do you re-add
the row?

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: kuznet@ms2.inr.ac.ru
Date:
Subject: Re: Fwd: Re: Fwd: Problem with recv syscall on socket when other side closed connection
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Re: Statistical aggregates