Re: [BUGS] Error in 8.0 rc5 with repeat calls to array operator

2005-01-17 Thread Daniel Ceregatti
This doesn't happen on a fresh initdb. In fact, it doesn't happen even directly after I load data. It might take a day or two, but eventually the problem manifests itself. I can reproduce it 100% of the time now. I've noticed this on 8rc1-5. Josh and I will get you a gdb trace ASAP. Daniel To

Re: [BUGS] Error in 8.0 rc5 with repeat calls to array operator

2005-01-16 Thread Tom Lane
Josh Berkus writes: > However, we're found that if you run thousands of empty array comparisons in > a > few seconds/minutes, eventually the empty array comparison breaks, and you > get: > ERROR: cache lookup failed for function 0 I tried while true; do echo "select '{}'::INT[] = '{}'::INT[]

Re: [BUGS] Error in 8.0 rc5 with repeat calls to array operator

2005-01-16 Thread Josh Berkus
Folks, > I'm finding an issue I thought was fixed with RC2, which is affecting my > ability to use arrays in RC5: Oh, this may be a bug specifically in INTARRAY; that module is installed. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

[BUGS] Error in 8.0 rc5 with repeat calls to array operator

2005-01-16 Thread Josh Berkus
Developers, I'm finding an issue I thought was fixed with RC2, which is affecting my ability to use arrays in RC5: Summary: Fast repeated calls to INT[] = INT[] operator causes error Severity: Query Failure Version: 8.0.0rc5, previous builds of 8.0.0 Platform: Gentoo Linux Description: Th