Bas van der Linden <bas(at)mike(dot)amaze(dot)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