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

RE: [HACKERS] DROP TABLE inside a transaction block

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Philip Warner" <pjw(at)rhyme(dot)com(dot)au>
Cc: "Lamar Owen" <lamar(dot)owen(at)wgcr(dot)org>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Mike Mascari" <mascarm(at)mascari(dot)com>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Tatsuo Ishii" <t-ishii(at)sra(dot)co(dot)jp>, <pgsql-hackers(at)postgreSQL(dot)org>
Subject: RE: [HACKERS] DROP TABLE inside a transaction block
Date: 2000-03-08 10:12:43
Message-ID: 000b01bf88e6$d7ac1d60$2801007e@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
> -----Original Message-----
> From: owner-pgsql-hackers(at)postgreSQL(dot)org
> [mailto:owner-pgsql-hackers(at)postgreSQL(dot)org]On Behalf Of Tom Lane
>
> Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> > For the ignorant, are you able to explain why naming files
> > '<table_name>_<IOD>' is not acceptable? This seems to satisfy both
> > requirements (and seemed to be the conclusion of the previous
> discussion).
>
> Well, it's pretty simple: consider what has to happen to make RENAME
> TABLE be rollback-able.
>

Is it necessary to get the relation path name from the relation name/oid etc
each time ?
Is it bad to keep the relation path name in pg_class(or another relation) ?
If a new vessel is needed for copy(etc)ing existent tuples we have to
allocate
another unique path name otherwise we can use already allocated file name.
And is it good to dicide the unique path name from oid/relname etc ?

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp


In response to

Responses

pgsql-hackers by date

Next:From: Mark HollomonDate: 2000-03-08 13:05:20
Subject: Re: [HACKERS] DROP TABLE inside a transaction block
Previous:From: Hiroshi InoueDate: 2000-03-08 09:40:20
Subject: RE: [HACKERS] DROP TABLE inside a transaction block

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