Temporary tables

Started by Juris Kruminsover 22 years ago2 messagesgeneral
Jump to latest
#1Juris Krumins
juriskr@komin.lv

Hello everybody.
Sorry for my english, it's no my native language. So I have problem with my
PostgreSQL 7.3.3 server. Untill now everything works fine, but now I get
lot's of errors:

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: cache lookup of
relation 149064743 failed . in table.php on line 169
Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: Relation
"tmp_table1" does not exist . in table.php on line 177
Warning: pg_numrows(): supplied argument is not a valid PostgreSQL result
resource in table.php on line 196
Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: Relation
"tmp_table1" does not exist . in table.php on line 221

The only reason of it as I can imagine is high load to server. Can it be so
and if it's not, can anybody tell me reason of it and are there any options
I can change to avoid this situation in future.
Thanks.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Juris Krumins (#1)
Re: Temporary tables

"Juris Krumins" <juriskr@komin.lv> writes:

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: cache lookup of
relation 149064743 failed . in table.php on line 169

What query is causing this, exactly?

Is it repeatable in the same database?

regards, tom lane