Re: Prevent extension creation in temporary schemas

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