On Thu, 20 Nov 2003, Tom Lane wrote:
> Andrei Ivanov <andrei.ivanov@ines.ro> writes:
> > select * from pg_rewrite where ev_class = 'pg_user'::regclass gives
> > [ lots of cruft ]
>
> Well, that's interesting, because I get exactly the same data from my
> perfectly-functional 7.3.4 installation.
>
> I think there must be some incompatibility between your data directory
> and your Postgres executable, but it's hard to think what. Have you
> verified that your executable really is 7.3.4 (try "select version()")?
PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2
20031022 (Gentoo Linux 3.3.2-r2, propolice)
>
> I suppose it could also be that the problem is not in pg_user after all,
> but some other view. I didn't think pg_get_viewdef() would use any
> other views, but I might be mistaken. Can you successfully do
> pg_get_viewdef on any other views --- pg_tables or pg_indexes for
> example?
>
template1=> select pg_get_viewdef('pg_tables'::regclass);
ERROR: nodeRead: did not find '}' at end of plan node
template1=> select pg_get_viewdef('pg_indexes'::regclass);
ERROR: nodeRead: did not find '}' at end of plan node
template1=>
> Also, how did you get into this state, exactly? I cannot believe that
> it's a matter of a forced shutdown; I think there must be some kind of
> software compatibility issue involved. What system updates have you
> done recently?
>
> regards, tom lane
I really can't think of anything else that could have brought postgresql
in this state... (could on minor update to glibc cause this ? I don't
remember if updated glibc before or after the corruption...)
