pg_roles: unrecognized token: ":aliasname"
In an up-to-date HEAD server that was initdb'd on 12 Feb (catalog
version 200602112):
test=> SELECT * FROM pg_roles;
ERROR: unrecognized token: ":aliasname"
test=> SELECT pg_get_viewdef('pg_roles'::regclass, true);
ERROR: unrecognized token: ":aliasname"
This breaks several things, including pg_dump. A newly-initdb'd
cluster doesn't have the problem. Was something changed that should
have bumped the catalog version?
--
Michael Fuhr
Michael Fuhr <mike@fuhr.org> writes:
In an up-to-date HEAD server that was initdb'd on 12 Feb (catalog
version 200602112):
test=> SELECT * FROM pg_roles;
ERROR: unrecognized token: ":aliasname"
test=> SELECT pg_get_viewdef('pg_roles'::regclass, true);
ERROR: unrecognized token: ":aliasname"
This breaks several things, including pg_dump. A newly-initdb'd
cluster doesn't have the problem. Was something changed that should
have bumped the catalog version?
Looks like Neil's fault: he changed struct Query on Sunday.
If things are OK after initdb, then it's just a minor faux pas ...
regards, tom lane