Обсуждение: pg_roles: unrecognized token: ":aliasname"

Поиск
Список
Период
Сортировка

pg_roles: unrecognized token: ":aliasname"

От
Michael Fuhr
Дата:
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


Re: pg_roles: unrecognized token: ":aliasname"

От
Tom Lane
Дата:
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