Re: Check whether a NOT NULL check constraint has been validated
| От | Stuart Campbell |
|---|---|
| Тема | Re: Check whether a NOT NULL check constraint has been validated |
| Дата | |
| Msg-id | CAAZ6SnyOHAcMHwAhj4fYUN2jp8FMQzSgTotifRG8Rz4tpGEMWQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Check whether a NOT NULL check constraint has been validated (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-general |
Hi Adrian,
Now I am not sure what you did.
Are you saying you used a CHECK constraint to check for NULL values?
That's right. Something like:
ALTER TABLE foo ADD CONSTRAINT bar_not_null CHECK (bar IS NOT NULL) NOT VALID
If so then pg_constraint.convalidated would work.
You're right. I didn't immediately find what I was looking for, and when I looked at the docs for pg_constraints, I guess I confused myself with this comment:
> Not-null constraints are represented in the
pg_attribute catalog, not here.This communication and any attachments may contain confidential information and are intended to be viewed only by the intended recipients. If you have received this message in error, please notify the sender immediately by replying to the original message and then delete all copies of the email from your systems.
В списке pgsql-general по дате отправления: