Martin Sarsale <[EMAIL PROTECTED]> writes:
> Im running debian stable/testing, postgresql 7.3.2 with a "connect by
> prior" patch.
Oh. You know, there's a reason why that patch isn't in the tree. Back
it out...
If you really want to use that patch, dump your database without the
patch, install
> Can you do "select * from pg_user" in any of your databases, or does it
> fail the same way in all? If it fails in each database then I'd suspect
> some kind of version mismatch; if not then it's just corrupt in that
> particular database.
I've only 2 databases t(template1 and another one) and
"Eduardo Naschenweng" <[EMAIL PROTECTED]> writes:
> Hi, I has a problem with a production database Postgres 7.1.2.
Ouch, that's pretty old (and not even the latest of the 7.1 series).
> The point is : I think some system table was corrupted.
Can you find any pg_class rows with OIDs matching thos
Hi, I has a problem with a production database Postgres 7.1.2.
Happens when finished free space disk.
Some important tables were empty with no reason.
I tried to find respectives files for tables with psql command
:
select relfilenode from pg_classwher
Yo Scott, Greg & William!
I tried to send the following message last week, but my posting never
got here. Guess my provider has fucked up. So here goes again, sorry
for late reply.
For knowledgeable feedback I have asked, and that's what I have got.
Thanx a lot. My thanks also Jim Wilson who ad