Thread: AW: [HACKERS] Re: [GENERAL] drop/rename table and transactions

> I look at this and question the value of allowing such fancy 
> things vs.
> the ability to look at the directory and know exactly what table is
> which file.  Maybe we can use file names like 23423_mytable 
> where 24323
> is the table oid and mytable is the table name.  That way, we can know
> the table, and they are unique too to allow RENAME TABLE to work.
> 
> This doesn't solve Vadim's problem.  His additional work would be to
> write a line to the log file for each table create/delete saying I
> deleted this table with this oid, and when reading back the 
> log, he has
> to record the oid_username combination and use that to 
> translate his log
> oids into actual filenames.

Why that ? 

24323_* will point to the correct table segments inside the db directory.
No need to actually know what * matches to, no ?

Andreas 

> > This doesn't solve Vadim's problem.  His additional work would be to
> > write a line to the log file for each table create/delete saying I
> > deleted this table with this oid, and when reading back the 
> > log, he has
> > to record the oid_username combination and use that to 
> > translate his log
> > oids into actual filenames.
> 
> Why that ? 
> 
> 24323_* will point to the correct table segments inside the db directory.
> No need to actually know what * matches to, no ?

True.  If we go with tablename_OID format, then vadim will have to scan
directory and pick up all his oids and map them to file names before
spinning through the log.  Yes, it is a little more work, but worth it.

If you put the oid at the beginning, it is easier, but it is still an
issue because you have to issues a scandir command to find the matching
name for each oid.  Actually, he can do that no matter where the oid is
stored in the name.  That may be the way he has to handle it.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@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