When did the constitution become effective?

The constitution was ratified in 1788, but I've been told in a previous question on here that it only become effective in 1792. Is this true? If so, how?