When generating a PostgreSQL backup, it generates a lot of warnings:

[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/db/extractor/postgres_extractor.php on line 228: Undefined array key "consrc"

Because of this issue, constraints are not declared in the CREATE TABLE statements.