Skip site navigation (1) Skip section navigation (2)

Re: heap_create with OID?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: chris(at)bitmead(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: heap_create with OID?
Date: 2000-07-04 16:14:41
Message-ID: 200007041614.MAA26877@candle.pha.pa.us (view raw or flat)
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-07-04 16:16:29
Subject: Re: [PATCHES] Re: Statistical aggregates
Previous:From: Karel ZakDate: 2000-07-04 16:06:02
Subject: Re: heap_create with OID?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group