Hi Baji, I tested v3 together with the CHECK patch on top of b936425002c. Both apply cleanly and build without warnings. Driving psql through a pty and comparing against master: - ALTER CONSTRAINT fk DEFERRABLE <tab> offers INITIALLY DEFERRED and INITIALLY IMMEDIATE, and DEFERRABLE INITIALLY <tab> offers DEFERRED and IMMEDIATE.
- ALTER CONSTRAINT fk NOT DEFERRABLE <tab> completes to INITIALLY IMMEDIATE. - Everything that worked in v2, including the CHECK modifiers, gives the same output in v3, and the neighbouring ALTER TABLE rules are identical to master. The new forms are all accepted by the server, and src/bin/psql/t/ 010_tab_completion.pl passes. One correction to my previous mail, v2 of the CHECK patch applies to master on its own as well. v3 looks good to me. Regards, Surya Poondla
