Re: heap_create with OID?

At 02:14 5/07/00 -0400, Tom Lane wrote:
>
>> 1. createdb
>> 2. load all blobs
>> 3. Do remaining restore steps
>
>If you're reloading everything in OID order, then blobs need no special
>ordering treatment ;-)

It's actually a bit more complex than that, in that for efficiency I put
indexes, triggers, and ACLs at the end, just after date, which once more
introduces the possibility of a conflict. 

Also, the ordering is fine, but with data loading (without OID), it still
may fail (unless I put the data after the BLOBs), so a strict OID order
won't work without OID based data load. And again, that would also need to
be done in OID order, which is a big ask.

Personally, I dislike the the concept of being able to set OID on some
things but not on others. I'd prefer a lower level backup interface to
allow creation of dumped entities with specified OIDs (ie. tables, indexes
etc). That way we get a database that is indistinguishable from the
original. This might wait to see what backup techniques are possible after
WAL & slot reuse.

This is not an argument for heap_create_oid, unless it is extended to *all*
database entities, which some other people might favour. I'd be interested
in other people's thoughts on this, since I am somewhat out of my depth!


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/