Re: Reconstructing FKs in pg_dump

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: Reconstructing FKs in pg_dump
Дата
Msg-id 1033074909.6610.12.camel@camel
обсуждение исходный текст
Ответ на Reconstructing FKs in pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Reconstructing FKs in pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, 2002-09-26 at 16:57, Tom Lane wrote:
<snip>
> There are a couple things I think we should do.  One: modify the CREATE
> CONSTRAINT TRIGGER code to try to extract a foreign relation name from
> the tgargs if FROM is missing.  Without this, we have no hope of loading
> working FK trigger definitions from old dumps.  Two: modify pg_dump to
> extract a name from the tgargs in the same fashion.  I'd rather have
> pg_dump do this than the backend, and this will at least make things
> better in the case where you're using a 7.3 pg_dump against an older
> database.
<snip>
> 
> Thoughts?
> 

I'm trying to think of the cases where this extraction might fail, but
maybe more important is what happens if it does fail? 

Robert Treat



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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: [GENERAL] Performance while loading data and indexing
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Reconstructing FKs in pg_dump