Re: pg_roles: unrecognized token: ":aliasname" - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_roles: unrecognized token: ":aliasname"
Date
Msg-id 22766.1140712227@sss.pgh.pa.us
Whole thread Raw
In response to pg_roles: unrecognized token: ":aliasname"  (Michael Fuhr <mike@fuhr.org>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Michael Fuhr
Date:
Subject: pg_roles: unrecognized token: ":aliasname"
Next
From: Ron Peacetree
Date:
Subject: Looking for a tool to "*" pg tables as ERDs