Postgres Pro
Downloads
Home   >   mailing lists

Thread: ERROR: typeidTypeRelid: Invalid type - oid = 0

ERROR: typeidTypeRelid: Invalid type - oid = 0

From
"Matt Magoffin (Borders Online)"
Date:
I've read many postings of people having this same problem, which I am now
having since I've updated to LinuxPPC R5. At this point I've compiled a
completely NEW database from scratch (with no problems) and, following right
along in the install docs, run %initdb, %createdb, %psql (and then the
"select datetime 'now';" query), and finally %destroydb, which produces the
error

ERROR:  typeidTypeRelid: Invalid type - oid = 0

Has there been any patch or work-around yet? (David, I saw you had submitted
a Bug report).

-- M@

Re: [GENERAL] ERROR: typeidTypeRelid: Invalid type - oid = 0

From
"David R. Favor"
Date:
"Matt Magoffin (Borders Online)" wrote:
>
> I've read many postings of people having this same problem, which I am now
> having since I've updated to LinuxPPC R5. At this point I've compiled a
> completely NEW database from scratch (with no problems) and, following right
> along in the install docs, run %initdb, %createdb, %psql (and then the
> "select datetime 'now';" query), and finally %destroydb, which produces the
> error
>
> ERROR:  typeidTypeRelid: Invalid type - oid = 0
>
> Has there been any patch or work-around yet? (David, I saw you had submitted
> a Bug report).
>
> -- M@

The only way I can get gcc to work is to use -O0 to turn off all optimization.

If you figure out what's wrong, be sure to post it to this list and the egcs list.

A few queries

From
M Simms
Date:
Hi

I have just installed 6.5, and I have a couple of questions that I cannot find
the answer to in the documentation.

Firstly, I am using temporary tables for a number of operations. Is
there a way to direct postgresql to keep these in memory for fast
access, or will it do this anyway?

Secondly, is there a way to instruct postgresql to process a query at
a lower priority, for things like daily maintainence routines that I
dont want to have slowing down the rest of the database ops by taking
all the cpu

Thirdly, how often should I vacuum a database. Is there a general rule
as to how many inserts or updates between vacuums is optimal?

Thanks

                    M Simms

Re: [GENERAL] ERROR: typeidTypeRelid: Invalid type - oid = 0

From
Bruce Momjian
Date:
> "Matt Magoffin (Borders Online)" wrote:
> >
> > I've read many postings of people having this same problem, which I am now
> > having since I've updated to LinuxPPC R5. At this point I've compiled a
> > completely NEW database from scratch (with no problems) and, following right
> > along in the install docs, run %initdb, %createdb, %psql (and then the
> > "select datetime 'now';" query), and finally %destroydb, which produces the
> > error
> >
> > ERROR:  typeidTypeRelid: Invalid type - oid = 0
> >
> > Has there been any patch or work-around yet? (David, I saw you had submitted
> > a Bug report).
> >
> > -- M@
>
> The only way I can get gcc to work is to use -O0 to turn off all optimization.
>
> If you figure out what's wrong, be sure to post it to this list and the egcs list.
>
>


We have updated template/linux_ppc with:

    CFLAGS:-O0 -mieee # optimization -O2 removed because of egcs problem

We understand the cause.  It is our bug, not egcs.  egcs is just better
at optimization on that platform than most.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026