NOTICE:  table "tmp" does not exist, skipping
CONTEXT:  SQL statement "drop table if exists tmp"
PL/pgSQL function "f"(integer) line 20 at SQL statement
ERROR:  could not open file "base/830972/t27_3187681": No such file or directory
CONTEXT:  SQL statement "create temporary table tmp(
...
     )"
PL/pgSQL function "f"(integer) line 21 at SQL statement

********** Ошибка **********

ERROR: could not open file "base/830972/t27_3187681": No such file or directory
SQL-состояние: 58P01
Контекст: SQL statement "create temporary table tmp(
...
     )"
PL/pgSQL function "f"(integer) line 21 at SQL statement

CREATE OR REPLACE FUNCTION "f"(IN f integer)
  RETURNS TABLE(f integer) AS
$BODY$
 begin
     drop table if exists tmp;
     create temporary table tmp(
...
     );
...
    return query select * from tmp;
 end;
 $BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100
  ROWS 1000;

select 'drop table ' || nspname || '."' || relname || '";'
from pg_class c
join pg_namespace n on n.oid = c.relnamespace
where relkind = 'r' and c.relpersistence = 't'