Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Vadim Mikheev <vadim@krs.ru>
From: Vadim Mikheev <vadim@krs.ru>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Mike Mascari <mascarm@mascari.com>, Lamar Owen <lamar.owen@wgcr.org>, Tom Lane <tgl@sss.pgh.pa.us>, Lincoln Yeoh <lylyeoh@mecomb.com>, pgsql-general@postgreSQL.org, PostgreSQL Developers List <hackers@postgreSQL.org>
Date: 1999-11-29T06:52:25Z
Lists: pgsql-hackers
Bruce Momjian wrote: > > > I have to say that I'm going to change on-disk database/table/index > > file names to _OID_! This is required by WAL because of inside of > > log records there will be just database/table/index oids, not names, > > and after crash recovery will not be able to read pg_class to get > > database/table/index name using oid ... > > Wow, that is a major pain. Anyone else think so? Why it's so painful? We can write utility to construct database dir with table names symlinked to real table files -:) Actually, I don't understand for what would you need to know what is what, (c) -:) > Using oid's instead of names may give us some ability to fix some other > bugs, though. Yes. Vadim