| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | David Wall <d(dot)wall(at)computer(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: reindexdb program error under PG 8.1.3 |
| Date: | 2006-05-25 20:06:48 |
| Message-ID: | 15444.1148587608@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
David Wall <d(dot)wall(at)computer(dot)org> 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 "xxxx" 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 something that's misconfigured in the template1 database
> (we have not customized it), something we're doing wrong, or is this
> "normal"?
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-created
object. Look in template1 and see if you see a table with that OID.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Wall | 2006-05-25 21:07:27 | Re: reindexdb program error under PG 8.1.3 |
| Previous Message | Rafal Pietrak | 2006-05-25 19:42:02 | Re: background triggers? |