Re: [GENERAL] Creating temp tables inside read only transactions - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: [GENERAL] Creating temp tables inside read only transactions
Date
Msg-id 1310192343.3012.192.camel@jdavis
Whole thread Raw
In response to Re: [GENERAL] Creating temp tables inside read only transactions  (Darren Duncan <darren@darrenduncan.net>)
List pgsql-hackers
On Fri, 2011-07-08 at 12:34 -0700, Darren Duncan wrote:
> Yes, but that would just be in-memory or in temporary places external to every
> database.  On disk internal to a database there would just be the oid.  In fact,
> another aspect of the database model I defined is that each "database" is
> entirely self-contained; while you can do cross-database queries, you don't have
> cross-database constraints, in the general case.

Yes, you can have a "local oid" and a "fully-qualified oid". It sounds
like it might take some effort (which is an understatement) to go
through the system and figure out which ones should be local and which
ones should be fully-qualified.

Regards,
    Jeff Davis


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Creating temp tables inside read only transactions
Next
From: Darren Duncan
Date:
Subject: Re: [GENERAL] Creating temp tables inside read only transactions