>
>     "Fiscal year" double precision,
>

This column is an INTEGER in your other table, so your schema is not even
internally consistent! Try to use TEXT, INT, DATE and TIMESTAMPTZ whenever
possible, with NUMERIC as needed for things with a precision. See:

https://www.postgresql.org/docs/current/datatype-numeric.html

Cheers,
Greg

P.S. +1 for use of an identity column, though.

Reply via email to