Simple one-to-one relation throws error

Quite possible, what version of PG are you using? The minimum accepted version is PG 10