Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-14 Thread Mendola Gaetano
"Tom Lane" <[EMAIL PROTECTED]> > Stephan Szabo <[EMAIL PROTECTED]> writes: > > I got the same thing as Gaetano on my just prior to beta1 system. > > Well, we couldn't have fixed it since beta1 --- there's been no changes > anywhere near SPI. I'm thinking it must be platform-dependent. What > are

Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-14 Thread Tom Lane
"Gaetano Mendola" <[EMAIL PROTECTED]> 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=# Anyon

[HACKERS] consistency check on SPI tuple count failed

2003-08-14 Thread Gaetano Mendola
Hi all, 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. CREATE TABLE test ( a integer, b integer ); INSERT INTO test VALUES ( 1 ); CREATE OR REPLACE FUNCTION foo(INTEGER) RETURNS INTEGER AS'

Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-14 Thread Tom Lane
"Mendola Gaetano" <[EMAIL PROTECTED]> writes: > Incredible to believe but after playng around that funcion started > to work. I'm not crazy. Yeah, it was a problem with storing into a possibly-obsolete pointer --- the visible effects could range from nothing to a core dump depending on whether th

Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-14 Thread Tom Lane
"Mendola Gaetano" <[EMAIL PROTECTED]> writes: > 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 > CONTEX

Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-14 Thread Mendola Gaetano
"Tom Lane" <[EMAIL PROTECTED]> wrote: > "Gaetano Mendola" <[EMAIL PROTECTED]> 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=# sele

Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-14 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > I got the same thing as Gaetano on my just prior to beta1 system. Well, we couldn't have fixed it since beta1 --- there's been no changes anywhere near SPI. I'm thinking it must be platform-dependent. What are you guys using, exactly?

Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-14 Thread Rod Taylor
On Fri, 2003-08-08 at 11:55, Tom Lane wrote: > "Gaetano Mendola" <[EMAIL PROTECTED]> 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

Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-14 Thread Gaetano Mendola
I forgot to say to do a: select bar() at the end! Gaetano ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-14 Thread Stephan Szabo
On Fri, 8 Aug 2003, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > I got the same thing as Gaetano on my just prior to beta1 system. > > Well, we couldn't have fixed it since beta1 --- there's been no changes > anywhere near SPI. I'm thinking it must be platform-dependent. What

Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-09 Thread Stephan Szabo
On Fri, 8 Aug 2003, Tom Lane wrote: > "Mendola Gaetano" <[EMAIL PROTECTED]> writes: > > 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:

Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-08 Thread Stephan Szabo
On Fri, 8 Aug 2003, Tom Lane wrote: > "Gaetano Mendola" <[EMAIL PROTECTED]> 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

Re: [HACKERS] consistency check on SPI tuple count failed

2003-08-08 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Fri, 8 Aug 2003, Tom Lane wrote: >> I have also just traced through _SPI_cursor_operation() in spi.c, >> watched PortalRunFetch return 2, and then watched _SPI_checktuples read >> zero from _SPI_current->processed. How the heck could that happen? >> C