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; ??? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
