Re: Re: yowch: dumpRules(): SELECT failed for table website.

* SL Baur <steve@beopen.com> [000524 02:59] wrote:
> Alfred Perlstein <bright@wintelcom.net> writes in pgsql-hackers@postgresql.org:
> 
> > while doing a pg_dump of a table after postgresql made a mess of itself:
> 
> > dumpRules(): SELECT failed for table website.  Explanation from
> > backend: 'ERROR: cache lookup of attribute 1 in relation 9892634
> > failed '.
> 
> I just got a message like that earlier this afternoon.  My problem was
> that I had created a view and later dropped and recreated one of the
> tables the view referenced.  Dropping and recreating the view fixed
> things.

I'm not using views afaik.

There seems to be a serious corruption problem when a transaction
is aborted, I'll see if I can have a reproduceable bug report
tomorrow.

Afaik it has to do with a transaction aborting after inserting or
updating into a table.  Something seems to go seriously wrong.

We're also getting some problems when we don't "SET ENABLE_SEQSCAN=OFF;"
for certain queries, Postgresql takes a really unoptimal path and
will loop forever.

Btw, is there any way to specify an abort timeout for a query if it's
taking too long to just fail?

-- 
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."