| From: | Mike Adams <madams55075(at)comcast(dot)net> |
|---|---|
| To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
| Cc: | sconeek(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Cant find temp tables |
| Date: | 2006-04-07 00:01:11 |
| Message-ID: | 4435ABC7.3020909@comcast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dave Page wrote:
>
>
>> -----Original Message-----
>> From: pgsql-general-owner(at)postgresql(dot)org
>> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of
>> sconeek(at)gmail(dot)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 | Content-Type | Size |
|---|---|---|
| madams55075.vcf | text/x-vcard | 258 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2006-04-07 00:02:25 | Re: Large text data |
| Previous Message | Scott Marlowe | 2006-04-06 23:52:02 | Re: php to import csv to postgres |