ERROR: typeidTypeRelid: Invalid type - oid = 0

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

"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.

"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

Yes, updating the linux_ppc template to CFLAGS=O0 fixes all the problems.

Thanks for the help!

-- M@

-----Original Message-----
From: Bruce Momjian [mailto:maillist@candle.pha.pa.us]
Sent: Wednesday, June 23, 1999 3:05 PM
To: David R. Favor
Cc: Matt Magoffin (Borders Online); 'pgsql-general@postgresql.org';
'dfavor@gate.corridor.com'
Subject: Re: [GENERAL] ERROR: typeidTypeRelid: Invalid type - oid = 0

"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