Re: References not being checked while creating tables? - Mailing list pgsql-novice

Bas van der Linden <bas@mike.amaze.nl> writes:
> CREATE TABLE test (
> id        serial
> );

> CREATE TABLE test2 (
> another_id    text REFERENCES test(id)
> );

> This is accepted by the database, however, it obviously is of no use
> whatsoever as the data types are incompatible.

Yes, the type mismatch should be detected sooner.  I thought we had
fixed this for 7.1, but I see it still doesn't notice the problem
until runtime.  Oh well, another TODO item for 7.2 ...

            regards, tom lane