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

Re: Bug with DatabaseMetaData and temporary tables/schemas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bug with DatabaseMetaData and temporary tables/schemas
Date: 2010-11-07 01:02:41
Message-ID: 12764.1289091761@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
Kris Jurka <books(at)ejurka(dot)com> writes:
> It looks like psql will show you your own temp schema and all of the 
> temp toast schemas.  So that could potentially be improved as well.

Yeah, there was some discussion of that just recently:
http://archives.postgresql.org/message-id/16710.1284837096@sss.pgh.pa.us

I haven't got round to making that change yet, but maybe now is a
good time.  The consensus seemed to be that \dn (without S) should
not show any pg_XXX schemas, nor information_schema.  Not sure that
that's appropriate for getSchemas though --- an API intended for
programs should maybe just hide the temp and toast schemas.

			regards, tom lane

In response to

Responses

pgsql-jdbc by date

Next:From: Thomas KellererDate: 2010-11-07 08:43:33
Subject: Re: Bug with DatabaseMetaData and temporary tables/schemas
Previous:From: Kris JurkaDate: 2010-11-06 23:52:44
Subject: Re: Bug with DatabaseMetaData and temporary tables/schemas

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