Re: pg_dump with postgis extension dumps rules separately

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump with postgis extension dumps rules separately
Дата
Msg-id 21686.1370102229@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump with postgis extension dumps rules separately  (Joe Conway <mail@joeconway.com>)
Ответы Re: pg_dump with postgis extension dumps rules separately  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Joe Conway <mail@joeconway.com> writes:
> I can look at having pg_dump ignore these entries, but I suspect that
> will be quite a bit more invasive.

Actually, I believe the answer is just that getSchemaData() is doing
things in the wrong order:
   if (g_verbose)       write_msg(NULL, "reading rewrite rules\n");   getRules(fout, &numRules);
   /*    * Identify extension member objects and mark them as not to be dumped.    * This must happen after reading all
objectsthat can be direct members    * of extensions, but before we begin to process table subsidiary objects.    */
if(g_verbose)       write_msg(NULL, "finding extension members\n");   getExtensionMembership(fout, extinfo,
numExtensions);

Per that comment, getRules() should be called down where indexes,
constraints, and triggers are processed.
        regards, tom lane



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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: pg_dump with postgis extension dumps rules separately
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump with postgis extension dumps rules separately