On Mon, Jun 13, 2011 at 8:35 AM, jonathansfl <jonathanbrinkman@xxxxxxxxx> wrote: > How would I create a dynamic table name, using the loop increment as a > parameter? > > DROP TABLE IF EXISTS tt_PERSONSTODEACTIVATE || v_iteration CASCADE; > > that doesn't work. don't think i can use a dynamic variable as a table name, > so i can't build the table name as a variable. perhaps if the entire DROP > TABLE is inside dynamic SQL and I execute entire script. could try that, > although it's messy for such a simple problem. > > i still don't understand still why the TEMP tables are not acting TEMPORARY > and are not going away when their loop ends. 'execute' is for that: http://www.postgresql.org/docs/current/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN temp tables go away when the database session exits. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
