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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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