Andrei Ivanov <[EMAIL PROTECTED]> writes: > On Thu, 11 Dec 2003, Tom Lane wrote: >> Andrei Ivanov <[EMAIL PROTECTED]> writes: >>> template1=# select usename from pg_user; >>> ERROR: did not find '}' at end of input node >> >> There's something wrong with the ON SELECT rule for the pg_user view, >> evidently. Could we see the output of >> >> select * from pg_rewrite where ev_class = 16683;
> The ouput is attached... Well, that's interesting, because it's no different from what I get. So it seems the fault is not in your database but in the rule-reading routines. Are you sure you have a clean build of PG 7.4? I'm wondering about having a slightly out-of-sync version that's expecting slightly different contents of the rule structures. We make such changes regularly, but they're supposed to go along with catversion.h changes that prevent you from running the wrong server version against a database ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html