Re: pg_dump with tables created in schemas created by extensions

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: pg_dump with tables created in schemas created by extensions
Дата
Msg-id abb09d01-b836-16d4-0ae0-9ffaca7f3393@BlueTreble.com
обсуждение исходный текст
Ответ на Re: pg_dump with tables created in schemas created by extensions  (Martín Marqués <martin@2ndquadrant.com>)
Список pgsql-hackers
On 8/23/16 3:34 PM, Martín Marqués wrote:
> I found quite some other objects we should be checking as well, but
> this will add some duplication to the tests, as I'd just copy (with
> minor changes) what's in src/bin/pg_dump/t/002_pg_dump.pl
>
> I can't think of a way to avoid this duplication, not that it really
> hurts. We would have to make sure that any new objects added to one
> test, if needed, are added to the other (that's a bit cumbersome).

At one point I had some code that understood what object names (ie: 
AGGREGATE, TABLE, etc) went with what catalog tables, what ones lived 
inside a schema (as opposed to globally), and which ones were 
shared/global (cross-database). I think I needed this for some automatic 
handling of comments, but it's been a while. Maybe something like that 
would help reduce the duplication...
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: dump/restore doesn't preserve row ordering?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Block level parallel vacuum WIP