| From: | "Kuroda, Hayato" <kuroda(dot)hayato(at)jp(dot)fujitsu(dot)com> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Chris Travers" <chris(dot)travers(at)adjust(dot)com>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "dimitri(at)citusdata(dot)com" <dimitri(at)citusdata(dot)com> |
| Subject: | RE: Prevent extension creation in temporary schemas |
| Date: | 2019-02-28 06:13:40 |
| Message-ID: | 1F66B161998C704BABF8989B8A2AC0A31A6EA3@G01JPEXMBYT05 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dear Michael, Chris and Tom,
> Adding special cases to extensions strikes me as adding more
> funny corners to the behavior of the db in this regard.
I understand your arguments and its utility.
> For most of extensions, this can randomly finish with strange error
> messages, say that:
> =# create extension file_fdw with schema pg_temp_3;
> ERROR: 42883: function file_fdw_handler() does not exist
> LOCATION: LookupFuncName, parse_func.c:2088
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.
Best Regards,
Hayato Kuroda
Fujitsu LIMITED
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2019-02-28 06:21:40 | Re: Drop type "smgr"? |
| Previous Message | Tom Lane | 2019-02-28 06:08:39 | Re: Drop type "smgr"? |