David Wall <[EMAIL PROTECTED]> writes:
> Thanks, Robert. Actually, I noted that each time I ran my backup
> script, the OID mentioned in the error was bigger than previous number.
That's fairly interesting, but can you provide a self-contained test
case? The reindexdb script really doesn't do a
It really isn't neccessary. That said, there is *something* going on with your
db, so it might be prudent to figure out what it is.
Thanks, Robert. Actually, I noted that each time I ran my backup
script, the OID mentioned in the error was bigger than previous number.
Before I run the re
On Thursday 25 May 2006 19:34, David Wall wrote:
> Rats! I found nothing But just for grins, I ran the reindexdb
> program a second time, and this time it reported a different OID, higher
> than the previous. I know we didn't change the template1 database other
> than using it when creating
Rats! I found nothing But just for grins, I ran the reindexdb
program a second time, and this time it reported a different OID,
higher than the previous. I know we didn't change the template1
database other than using it when creating new databases, creating
users, tablespaces, etc.
My
David,
On Thu, May 25, 2006 at 02:07:27PM -0700, David Wall wrote:
> >object. Look in template1 and see if you see a table with that OID.
> Thanks, but I clearly lack that expertise. How do I find "a table with
> that OID"?
Do a normal select against pg_class. Something like:
select oid, rel
(repost to newsgroup since the other went directly to Mr. Lane's email
address)
I think you've done something to template1,
even though you say you
haven't. Out-of-the-box, an 8.1.3 database won't have any OIDs
assigned
above about 11000, so OID 41675 would have to belong to a user-crea
David Wall <[EMAIL PROTECTED]> writes:
> When I create a brand new database and then run the reindexdb program
> under PG 8.1.3, I get the follow error:
> reindexdb: reindexing of database "" failed: ERROR: could not open
> relation with OID 41675
> I'm not sure what this error is since we
When I create a brand new database and then run the reindexdb program
under PG 8.1.3, I get the follow error:
reindexdb: reindexing of database "" failed: ERROR: could not open
relation with OID 41675
I'm not sure what this error is since we have not even added any data
yet. Is this so
