<kynn(at)panix(dot)com> writes:
> Now, suppose that one had to insert many records at once. Is it
> possible to mimic the above strategy by turning off the constraints
> and indexing temporarily (without dropping them altogether), and
> turning them back on after all the inserts have been made.
No. You can drop and re-add them if you have a mind to. People
do this fairly often with indexes and foreign key constraints ---
there's no advantage in doing it for CHECK constraints though.
regards, tom lane