Re: Cant find temp tables - Mailing list pgsql-general

From Mike Adams
Subject Re: Cant find temp tables
Date
Msg-id 4435ABC7.3020909@comcast.net
Whole thread Raw
In response to Re: Cant find temp tables  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-general
Dave Page wrote:
>
>
>> -----Original Message-----
>> From: pgsql-general-owner@postgresql.org
>> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of
>> sconeek@gmail.com
>> Sent: 03 April 2006 01:21
>

...snip

>
> 2) pgAdmin uses a separate connection for query tool windows. Because
> temp tables exist only for the life of the session, if you close the
> query tool (or whatever other session you created the table in), all the
> pg_class/pg_attribute rows will be removed so pgAdmin won't see them no
> matter how much you refresh the tree.
>

Regarding item 2), is there a way to *disconnect* pgAdmin from a
database (ie drop the connection) thereby allowing you to modify
template1 for example, disconnect from template1 so another person can
initdb using template1 on another connection w/o you having to shutdown
pgAdmin?

Attachment

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: php to import csv to postgres
Next
From: Scott Marlowe
Date:
Subject: Re: Large text data