Re: How to get schema name which violates fk constraint

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: How to get schema name which violates fk constraint
Дата
Msg-id 760EC27241A6495F87DC92FC1B9685BF@andrusnotebook
обсуждение исходный текст
Ответ на Re: How to get schema name which violates fk constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> The type of fix I'd like to see would be to not change message texts at
> all, but to add separate error-message fields for the name and schema
> name of object(s) involved in an error; which would be details that
> psql, for example, would show only in VERBOSE mode.  Note that error
> report fields along this line are actually required by the SQL spec
> (cf GET DIAGNOSTICS) but we've never got round to implementing 'em.

How about adding also a way to get primary key value(s) of the row which
causes error ?

Andrus.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to get schema name which violates fk constraint
Следующее
От: "Andrus"
Дата:
Сообщение: Re: Shopping cart