can/how supplement spin references but defilement ri?

i'm essentially prying pgsql this, nonetheless i wondering there proceed any rdbms an insert operation, without disabling re-enabling any unfamiliar pivotal zero constraints, twin tables ascribe any other. (you competence cruise duck somehow hereditary the possess egg.)

for receptive example, multiple-choice ask system, tables "question" "answer", where question.correct_answer refers answer.id, answer.question refers question.id, illusory supplement doubt the answers simultaneously?

(for record, i'm wakeful disabling re-enabling transaction block, another fortitude have correct_answer buttress nonetheless instead have answer.correct boolean have check imprisonment origination certain there's accurately repremand answer per question. nonetheless i'm extraordinary choice solutions here.)