public inbox for [email protected]  

help / color / mirror / Atom feed

Doc error re: "not null" "not valid"
3+ messages / 2 participants
[nested] [flat]

* Doc error re: "not null" "not valid"
@ 2026-06-18 04:15 Pete O'Such <[email protected]>
  2026-06-18 04:26 ` Re: Doc error re: "not null" "not valid" David G. Johnston <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Pete O'Such @ 2026-06-18 04:15 UTC (permalink / raw)
  To: [email protected]

https://www.postgresql.org/docs/9.1/sql-altertable.html

The text for "ADD table_constraint" says that NOT VALID "is currently only
allowed for foreign key constraints." Testing with 18.4 shows that this is
incorrect. A brief example of it working for a NOT NULL constraint is
available here:
https://neon.com/postgresql/18/not-null-as-not-valid

It looks like this is correctly noted as working in the 18.0 release notes
( https://www.postgresql.org/docs/release/18.0/ ), but not in the main docs.

Thank you!

-Pete O'Such


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Doc error re: "not null" "not valid"
  2026-06-18 04:15 Doc error re: "not null" "not valid" Pete O'Such <[email protected]>
@ 2026-06-18 04:26 ` David G. Johnston <[email protected]>
  2026-06-18 04:45   ` Re: Doc error re: "not null" "not valid" Pete O'Such <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: David G. Johnston @ 2026-06-18 04:26 UTC (permalink / raw)
  To: Pete O'Such <[email protected]>; +Cc: [email protected] <[email protected]>

On Wednesday, June 17, 2026, Pete O'Such <[email protected]> wrote:

> https://www.postgresql.org/docs/9.1/sql-altertable.html
>
> The text for "ADD table_constraint" says that NOT VALID "is currently only
> allowed for foreign key constraints."
>
>
You are commenting on version 9.1 documentation but testing version 18.
The 18 docs mention not-null constraints.

David J.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Doc error re: "not null" "not valid"
  2026-06-18 04:15 Doc error re: "not null" "not valid" Pete O'Such <[email protected]>
  2026-06-18 04:26 ` Re: Doc error re: "not null" "not valid" David G. Johnston <[email protected]>
@ 2026-06-18 04:45   ` Pete O'Such <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Pete O'Such @ 2026-06-18 04:45 UTC (permalink / raw)
  To: David G. Johnston <[email protected]>; +Cc: [email protected] <[email protected]>

>
> You are commenting on version 9.1 documentation but testing version 18.
> The 18 docs mention not-null constraints.


That's totally right. Thanks for setting me straight.

Pete

On Thu, Jun 18, 2026 at 12:26 AM David G. Johnston <
[email protected]> wrote:

> On Wednesday, June 17, 2026, Pete O'Such <[email protected]> wrote:
>
>> https://www.postgresql.org/docs/9.1/sql-altertable.html
>>
>> The text for "ADD table_constraint" says that NOT VALID "is currently
>> only allowed for foreign key constraints."
>>
>>
> You are commenting on version 9.1 documentation but testing version 18.
> The 18 docs mention not-null constraints.
>
> David J.
>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2026-06-18 04:45 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-06-18 04:15 Doc error re: "not null" "not valid" Pete O'Such <[email protected]>
2026-06-18 04:26 ` David G. Johnston <[email protected]>
2026-06-18 04:45   ` Pete O'Such <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox