Re: unnailing shared relations (was Re: global temporary tables) - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: unnailing shared relations (was Re: global temporary tables)
Date
Msg-id 1274732269-sup-6739@alvh.no-ip.org
Whole thread Raw
In response to unnailing shared relations (was Re: global temporary tables)  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: unnailing shared relations (was Re: global temporary tables)
List pgsql-hackers
Excerpts from Robert Haas's message of vie may 21 10:20:38 -0400 2010:

> Actually, there's another way we could do this.   Instead of creating
> pg_shared_class and pg_shared_attribute and moving all of the catalog
> entries for the shared relations into those tables, we could consider
> leaving the catalog entries in the unshared copies of pg_class,
> pg_attribute, etc. and DUPLICATING them in a shared catalog which
> would only be used prior to selecting a database.  Once we selected a
> database we'd switch to using the database-specific pg_class et al.
> Obviously that's a little grotty but it might (?) be easier, and
> possibly a step along the way.

Uh, how does this work when you change the entries for shared relations
in a database-specific pg_class?  Keeping everything in sync seems hard,
if not impossible.

-- 
Álvaro Herrera <alvherre@alvh.no-ip.org>


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Exposing the Xact commit order to the user
Next
From: Robert Haas
Date:
Subject: Re: unnailing shared relations (was Re: global temporary tables)