| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | andrew(at)tao11(dot)riddles(dot)org(dot)uk |
| Subject: | BUG #15101: function set search_path = '' breaks dump/restore |
| Date: | 2018-03-08 06:59:21 |
| Message-ID: | 152049236165.23137.5241258464332317087@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15101
Logged by: Andrew Gierth
Email address: andrew(at)tao11(dot)riddles(dot)org(dot)uk
PostgreSQL version: 10.3
Operating system: any
Description:
Given:
create or replace function foo()
returns text language sql
as $$
select current_schemas(true)::text;
$$
set search_path = '';
dump/restore (or \ef) fails with:
ERROR: zero-length delimited identifier at or near """"
The problem obviously being that pg_get_functiondef is returning invalid
syntax for the search_path setting.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2018-03-08 08:08:58 | Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column |
| Previous Message | Peter Eisentraut | 2018-03-07 20:16:44 | Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column |