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

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

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Mike Mascari <mascarm(at)mascari(dot)com>, Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>, Lincoln Yeoh <lylyeoh(at)mecomb(dot)com>, pgsql-general(at)postgreSQL(dot)org, PostgreSQL Developers List <hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Date: 1999-11-29 08:00:44
Message-ID: 384232AC.C546A8C0@krs.ru (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Tom Lane wrote:
> 
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> >> 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?
> > Using oid's instead of names may give us some ability to fix some other
> > bugs, though.
> 
> Yes, and yes.  I've been trying to nerve myself to propose that, because
> it seems the only reasonable way to make rollback of RENAME TABLE and
> DROP TABLE work safely.  It'll be a pain in the neck for debugging and
> admin purposes though.

So, no more nerves needed, Tom, yeh? -:)
It would be nice if someone else, not me, implement this...

> Can we make some sort of usually-correct-but-not-guaranteed-correct
> dump that shows which corresponds to what?  Maybe something similar
> to the textfile dump of pg_shadow that the postmaster uses for password
> authentication?  Then at least you'd have some shot at figuring out
> which file was what in extremis...

As it was proposed - utility to create dir with database name
(in addition to dir with database oid where data really live)
and symlinks there: table_name --> ../db_oid/table_oid

Vadim

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 1999-11-29 08:10:34
Subject: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Previous:From: Vadim MikheevDate: 1999-11-29 07:55:15
Subject: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions

pgsql-general by date

Next:From: Tom LaneDate: 1999-11-29 08:10:34
Subject: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Previous:From: Vadim MikheevDate: 1999-11-29 07:55:15
Subject: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions

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