Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints

Поиск
Список
Период
Сортировка
От Álvaro Herrera
Тема Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints
Дата
Msg-id 7b188cf1-c618-42cc-bd18-27dfcc6e8ea4@app.fastmail.com
обсуждение исходный текст
Ответ на Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints  (jian he <jian.universality@gmail.com>)
Список pgsql-hackers
Hi

I've been giving this some final polish which have me time to think it through, and I think Peter is right. We should not be adding the new column, but instead RelationBuildTupleDesc should use its existing scan of pg_constraint to determine validity status of constraints. We may need in addition a further value for attnullability that means unknown, "a constraint exists but we don't know yet if it's valid or invalid" for the times when we scanned pg_attribute but not yet pg_constraint. I think it's not too large a patch on top of that we have.

I'm going on a little excursion now but should be back to work on this in a couple of hours.


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