If I try to press "tab" to complete ALTER TABLE <some_table> ALTER CO...
only COLUMN hint is shown, CONSTRAINT is missing
Yes, indeed. Supporting ALTER TABLE <foo> ALTER CONSTRAINT has proved not to be that complicated. Per se the patch attached. I haven't added the part about deferred constraints but still that's an improvement as it can go up to the constraint detection. --