9.1rc1 regression: EXPLAIN on information_schema.key_column_usage
Hi list,
It seems I have found a regression in PostgreSQL 9.1rc1 (from 9.0).
In many cases, running the following query fails:
db=# EXPLAIN select * from information_schema.key_column_usage;
ERROR: record type has not been registered
However, this is not always reproducible. It seems to occur more
likely on an empty database. At first I suspected uninitialized memory
access somewhere, but valgrind does not highlight anything obvious.
Trying to isolate the part of the view that causes the error also
didn't yield any results.
Similarly, information_schema.triggered_update_columns also
occasionally returns this error, but less reliably.
Regards,
Marti
Marti Raudsepp <marti@juffo.org> writes:
It seems I have found a regression in PostgreSQL 9.1rc1 (from 9.0).
In many cases, running the following query fails:
db=# EXPLAIN select * from information_schema.key_column_usage;
ERROR: record type has not been registered
Looks like I overlooked a case in get_name_for_var_field. Thanks,
will fix.
regards, tom lane