From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | gnanam(at)zoniac(dot)com, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Advise on dropping TEMP table/schema for my use case |
Date: | 2011-03-09 15:27:58 |
Message-ID: | 24163.1299684478@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> On Wed, Mar 9, 2011 at 3:06 AM, Gnanakumar <gnanam(at)zoniac(dot)com> wrote:
>>
>> So, now we've decided to either DROP TABLE pg_temp_xx.FOO or DROP SCHEMA
>> pg_temp_xx explicitly just before closing the connection (after step 3 and
>> before step 4), so that it'll not be visible for the next database
>> connection request. My question is, which one of the option is recommended
>> and why?
> Why can't you just do:
> DROP TABLE FOO;
Or if you don't want to remember what you've created, update to 8.3+
so you can use DISCARD? (Or really, so that pg_pool can use DISCARD
... it should be the connection pooler's responsibility to ensure that
you get a clean-looking session.)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-03-09 15:31:56 | Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8 |
Previous Message | Adrian Klaver | 2011-03-09 15:27:48 | Re: [GENERAL] FW: backup using pg_dump postgreSQL 8.3.8 |