Re: Get constrrelid for fk constraints that lost it

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Get constrrelid for fk constraints that lost it
Дата
Msg-id 20994.1033396076@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Get constrrelid for fk constraints that lost it  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: Get constrrelid for fk constraints that lost it  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-patches
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> ... If the table doesn't exist or there
> aren't enough args to intuit a table name, it currently
> elog errors.  Is that reasonable behavior, or should
> it be taking the constraint and letting it fail at
> runtime?

I was inclined to think it should take the constraint and let the
failure occur at runtime.  A NOTICE would be okay but not an ERROR.
(We can tweak the RI triggers to make the runtime failure message be
more helpful than "Relation 0 not found".)  ISTM the point of having
this hack is to allow old dump files to be loaded, and an ERROR would
get in the way of that.

            regards, tom lane

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

Предыдущее
От: "Zeugswetter Andreas SB SD"
Дата:
Сообщение: AIX compilation problems (was Re: [HACKERS] Proposal ...)
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Get constrrelid for fk constraints that lost it