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

Re: Big 7.1 open items

From: Chris Bitmead <chris(at)bitmead(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Big 7.1 open items
Date: 2000-07-01 03:59:26
Message-ID: 395D6C9E.23EFA5E8@bitmead.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:

> Now that you mention it, this is another reason why system tables for
> each database have to live in a separate tablespace directory: there's
> no other good way to do that final stage of DROP DATABASE.  The
> DROP-each-table approach doesn't work for system tables (somewhere along
> about the point where you drop pg_attribute, DROP TABLE itself would
> stop working ;-)).

If drop table is extended to drop multiple tables at once, then you read
and cache everything you need before doing all the destruction in the
second stage.

In response to

pgsql-hackers by date

Next:From: Chris BitmeadDate: 2000-07-01 04:04:19
Subject: Re: Misc. consequences of backend memory management changes
Previous:From: Chris BitmeadDate: 2000-07-01 03:20:12
Subject: Re: Makefile for parser

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