Re: Vacuuming leaked temp tables (once again)
Dave Page <dpage@pgadmin.org>
From: "Dave Page" <dpage@pgadmin.org>
To: "Simon Riggs" <simon@2ndquadrant.com>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, "Stephen Frost" <sfrost@snowman.net>, pgsql-hackers@postgresql.org
Date: 2008-07-11T23:57:24Z
Lists: pgsql-hackers
On Sat, Jul 12, 2008 at 12:41 AM, Simon Riggs <simon@2ndquadrant.com> wrote: > > On Fri, 2008-07-11 at 17:26 -0400, Tom Lane wrote: >> Simon Riggs <simon@2ndquadrant.com> writes: >> > So it would seem that we need a way of handling temp tables that doesn't >> > rely on catalog entries at all. >> >> That's a complete non-starter; I need go no farther than to point out >> that it would break clients that expect to see their temp tables >> reflected in pg_class and so forth. > > What does the SQL Standard say about the Information Schema I wonder/ Many apps were written long before we had one. Not too mention that it doesn't provide anything like all the info that PostgreSQL-specific tool (though not necessarily user apps) would likely need. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com