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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match