Re: Temporary table already exists

DEBUG:  building index "pg_toast_148085_index" on table "pg_toast_148085"
CONTEXT:  SQL statement "CREATE LOCAL TEMPORARY TABLE deck_types           ON COMMIT DROP           AS           SELECT stored_functions_v0.get_card_deck_types(t1.id_master_card) AS deck_type_ids           FROM ccg_schema.deck_composition T0           ,ccg_schema.cards_per_user T1           WHERE id_deck = p_id_deck             AND t1.id_owner = l_id_user             AND t0.id_card = t1.id_card"       PL/pgSQL function stored_functions_v0.get_deck_types(bigint) line 12 at SQL statement
STATEMENT:  SELECT * FROM stored_functions_v0.get_deck_master_properties($1)
LOG:  execute <unnamed>: SELECT typname FROM pg_catalog.pg_type WHERE oid = $1
DETAIL:  parameters: $1 = '1016'
LOG:  execute <unnamed>: SET application_name = ''
LOG:  execute <unnamed>: SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid
DETAIL:  parameters: $1 = '1016'
LOG:  execute <unnamed>: INSERT INTO admin.logs VALUES ('', '2014-02-05 16:15:13.249', 'it.redevogames.redevolib.classes.PgStoredExecutor', 'DEBUG', $$Executing SELECT * FROM stored_functions_v0.get_deck_from_id_user(?)$$, 'PgStoredExecutor.java:215', $$Executing SELECT * FROM stored_functions_v0.get_deck_from_id_user(?)       $$)
LOG:  execute <unnamed>: SELECT * FROM stored_functions_v0.get_deck_from_id_user($1)
DETAIL:  parameters: $1 = '51'
LOG:  execute <unnamed>: SET application_name = ''
LOG:  execute <unnamed>: INSERT INTO admin.logs VALUES ('', '2014-02-05 16:15:13.258', 'it.redevogames.redevolib.classes.PgStoredExecutor', 'DEBUG', $$Executing SELECT * FROM stored_functions_v0.get_deck_master_properties(?)$$, 'PgStoredExecutor.java:215', $$Executing SELECT * FROM stored_functions_v0.get_deck_master_properties(?)       $$)
LOG:  execute <unnamed>: SELECT * FROM stored_functions_v0.get_deck_master_properties($1)
DETAIL:  parameters: $1 = '1'
ERROR:  relation "deck_types" already exists
CONTEXT:  SQL statement "CREATE LOCAL TEMPORARY TABLE deck_types           ON COMMIT DROP           AS           SELECT stored_functions_v0.get_card_deck_types(t1.id_master_card) AS deck_type_ids           FROM ccg_schema.deck_composition T0           ,ccg_schema.cards_per_user T1           WHERE id_deck = p_id_deck             AND t1.id_owner = l_id_user             AND t0.id_card = t1.id_card"       PL/pgSQL function stored_functions_v0.get_deck_types(bigint) line 12 at SQL statement
STATEMENT:  SELECT * FROM stored_functions_v0.get_deck_master_properties($1)
ERROR:  current transaction is aborted, commands ignored until end of transaction block