Hi > I found that this strange error appears after making > temporary tables. > > test=> CREATE TEMPORARY TABLE temp (id int); > CREATE TABLE > test=> CREATE EXTENSION file_fdw WITH SCHEMA pg_temp_3; > ERROR: function file_fdw_handler() does not exist > > I would try to understand this problem for community and > my experience.
This behavior seems as not related to extensions infrastructure: postgres=# CREATE TEMPORARY TABLE temp (id int); CREATE TABLE postgres=# set search_path to 'pg_temp_3'; SET postgres=# create function foo() returns int as 'select 1' language sql; CREATE FUNCTION postgres=# select pg_temp_3.foo(); foo ----- 1 (1 row) postgres=# select foo(); ERROR: function foo() does not exist LINE 1: select foo(); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. postgres=# show search_path ; search_path ------------- pg_temp_3 (1 row) regards, Sergei