Re: Legacy foreign keys

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Legacy foreign keys
Дата
Msg-id 20071210195046.GE27126@alvh.no-ip.org
обсуждение исходный текст
Ответ на Legacy foreign keys  ("Peter Koczan" <pjkoczan@gmail.com>)
Ответы Re: Legacy foreign keys  ("Peter Koczan" <pjkoczan@gmail.com>)
Re: Legacy foreign keys  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Peter Koczan escribió:
> Hi all,
>
> I am having a problem with what appear to be legacy foreign keys in
> some of my databases (probably pre-7.2 days). They won't restore from
> 8.2 to 8.3, because the '<unnamed>' field in the called function isn't
> unique when I try to restore more than one of these legacy keys

8.3's pg_dump contains smarts to dump these things as normal FKs.  Try
it.

--
Alvaro Herrera                               http://www.PlanetPostgreSQL.org/
"Postgres is bloatware by design: it was built to house
 PhD theses." (Joey Hellerstein, SIGMOD annual conference 2002)

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

Предыдущее
От: lattab kader
Дата:
Сообщение: Postgres installation problem
Следующее
От: "Peter Koczan"
Дата:
Сообщение: Re: Legacy foreign keys