BUG #15101: function set search_path = '' breaks dump/restore

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15101: function set search_path = '' breaks dump/restore
Дата
Msg-id 152049236165.23137.5241258464332317087@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15101: function set search_path = '' breaks dump/restore
Re: BUG #15101: function set search_path = '' breaks dump/restore
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15101
Logged by:          Andrew Gierth
Email address:      andrew@tao11.riddles.org.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.


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identitycolumn
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identitycolumn