Re: consistency check on SPI tuple count failed - Mailing list pgsql-hackers

From Mendola Gaetano
Subject Re: consistency check on SPI tuple count failed
Date
Msg-id 04b001c35dca$cce1e880$152aa8c0@GMENDOLA2
Whole thread Raw
In response to consistency check on SPI tuple count failed  ("Gaetano Mendola" <mendola@bigfoot.com>)
Responses Re: consistency check on SPI tuple count failed
Re: consistency check on SPI tuple count failed
List pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> "Gaetano Mendola" <mendola@bigfoot.com> writes:
> > the following code was working properly under Postgres 7.3.X
> > I'm now running my regression test with Postgres 7.4beta1 and I'm
> > having the error in subj.
> 
> I tried this and got
> 
> regression=# select bar();
>  bar
> -----
>    0
> (1 row)
> 
> regression=#
> 
> Anyone else see the problem?
> 
> regards, tom lane

Incredible to believe but after playng around  that funcion started
to work. I'm not crazy.

I deleted the DB. 
Stopped postgres. 
Restart postgres.
Create the DB.
Create the language. 
Inserted my example.

Again the error:

kalman=# select bar();
ERROR:  consistency check on SPI tuple count failed
CONTEXT:  PL/pgSQL function "bar" line 5 at for over select rows
kalman=# select bar();
ERROR:  consistency check on SPI tuple count failed
CONTEXT:  PL/pgSQL function "bar" line 5 at for over select rows
server closed the connection unexpectedly       This probably means the server terminated abnormally       before or
whileprocessing the request.
 
The connection to the server was lost. Attempting reset: Failed.

Gaetano







pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: TODO items
Next
From: Joe Conway
Date:
Subject: Re: TODO items