Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > On Wed, Mar 9, 2011 at 3:06 AM, Gnanakumar <gnanam@xxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
