Re: Temporary table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Juris Krumins" <juriskr(at)komin(dot)lv>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Temporary table
Date: 2003-08-09 15:36:31
Message-ID: 5808.1060443391@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Juris Krumins" <juriskr(at)komin(dot)lv> writes:
> Always it's ok, so it's execute without any problems. But sometimes I get
> error like this :
> Warning: pg_exec()[function.pg-exec]:Query failed:ERROR: cache lookup of
> relation 149064743 failed.

Hmm, that seems bad. Is the given relation number always the same? Is
there a row with that OID in pg_class? (Try "select * from pg_class
where oid = 149064743".)

What PG version is this?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andre Truter 2003-08-09 17:06:35 File output functions in PL/pgSQL?
Previous Message Christopher Browne 2003-08-09 15:34:56 Re: postmaster(s) have high load average