Re: DEFERRABLE NOT NULL constraint

On Friday, February 8, 2013 at 19:34, Albe Laurenz wrote:

Gavan Schneider wrote:
>>Referring to:
>><http://www.postgresql.org/docs/current/static/sql-createtable.html>
>>
>>I really must have missed something so am
>>standing by for the 'gotcha'... please supply :)

>Further down on the page you quote, it says: ...

Thank you, it had to be somewhere. :)


And this leads to a thought. Why is it that in this chapter the 
documentation gives a synopsis which is not correct for the 
current implementation but relies on a negation much further 
down the page to properly describe the actual behaviour?

Mostly the manual follows the pattern of a correct synopsis 
(where correct means what this version will actually do) 
followed by a section setting out the differences from the 
standard and/or other implementations.

While this chapter of the current documentation is not in error 
overall it's a bit misleading.

Of course if anything is going to change my preference would be 
to leave the synopsis in its SQL conformant state and bring the 
implementation up to standard in this area, meaning we can drop 
the contradiction/'correcting' paragraph. And, no, I'm not 
holding my breath on this just now.

Regards
Gavan Schneider