On Wed, 2005-11-30 at 02:10 -0500, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > [...context omitted...]
> > We would need to flush all the blocks in the table out of cache at
> > commit time, for that table only.
>
> This seems striking close to the Old Concept of temp tables, which
> we got rid of for good-and-sufficient reasons. You might want to
> spend some time reviewing the archives before proposing that we
> reintroduce it.
My suggestion is that I use the same mechanism as was introduced for 8.1
with the CREATE TABLE AS SELECT statement.
Best Regards, Simon Riggs