Re: erroneous restore into pg_catalog schema

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: erroneous restore into pg_catalog schema
Дата
Msg-id m24negp33q.fsf@2ndQuadrant.fr
обсуждение исходный текст
Ответ на Re: erroneous restore into pg_catalog schema  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:
> Huh?  According to the comment, at least, we don't get here for a
> relocatable extension.  I don't see anything wrong with auto-creating
> the target schema for a non-relocatable extension.

I was not finding why I would trust the comment the other evening, hence
my proposal. I now see that parse_extension_control_file has this check:
       if (control->relocatable && control->schema != NULL)            ereport(ERROR,
(errcode(ERRCODE_SYNTAX_ERROR),                   errmsg("parameter \"schema\" cannot be specified when \"relocatable\"
istrue"))); 

So it's ok. I now wonder how do you install a relocatable extension with
schema = pg_catalog, which I assumed was possible when reading the code
the other day.

I feel like I'm missing something big for not reading the whole thread
in details. Will send the patch I just finished for some documentation
work, then have a more serious look. Sorry about sharing that much
confusion…

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: 9.3 Beta1 status report
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: pg_dump --snapshot