Re: Cant find temp tables

Поиск
Список
Период
Сортировка
От Mike Adams
Тема Re: Cant find temp tables
Дата
Msg-id 4435ABC7.3020909@comcast.net
обсуждение исходный текст
Ответ на Re: Cant find temp tables  ("Dave Page" <dpage@vale-housing.co.uk>)
Список 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?

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: php to import csv to postgres
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Large text data