Re: [BUGS] Segfaults and assertion failures with not too extraordinary views and queries

Great, this seems to solve the problem. Thanks for the prompt attention. On Feb 15, 2007, at 10:52 PM, Tom Lane wrote: Phil Frost <[EMAIL PROTECTED]> writes: I rebuilt my pg with the attached patch and it did indeed resolve the assertion failure the previous test produced. I tinkered some mor

Re: [BUGS] Segfaults and assertion failures with not too extraordinary views and queries

Phil Frost <[EMAIL PROTECTED]> writes: > I rebuilt my pg with the attached patch and it did indeed resolve the > assertion failure the previous test produced. I tinkered some more > and got this patched build to segfault with a slightly different > script, below. Sigh ... I looked through no

Re: [BUGS] Segfaults and assertion failures with not too extraordinary views and queries

Yeah, maybe I am the only one doing this to the planner. The optimizations which caused this error will be greatly appreciated when I stop getting segfaults, however :) I rebuilt my pg with the attached patch and it did indeed resolve the assertion failure the previous test produced. I tink

Re: [BUGS] Segfaults and assertion failures with not too extraordinary views and queries

Agh...I was afraid of that. What I've found so far is at , and the rest of thread in general. Obviously some of these problems are veil's, but for the test I sent previously I had deleted veil.so so it couldn't be blam

Re: [BUGS] Segfaults and assertion failures with not too extraordinary views and queries

I wrote: > Hm, I see the assert failure, but this example doesn't seem to crash > when asserts are off, and I'd not expect it to: it should either work or > elog(ERROR) in ExecRestrPos. So maybe you've found more than one issue. The attached patch fixes the failure you exhibited, but I still don'

Re: [BUGS] Segfaults and assertion failures with not too extraordinary views and queries

Phil Frost <[EMAIL PROTECTED]> writes: > I have been attempting to migrate my application from 8.1 to 8.2.3. > In doing so, I found some queries would always cause the postgres > backend to die with a segfault. I was advised to rebuild with -- > enable-debug --enable-cassert, and so I did. The

[BUGS] Segfaults and assertion failures with not too extraordinary views and queries

I have been attempting to migrate my application from 8.1 to 8.2.3. In doing so, I found some queries would always cause the postgres backend to die with a segfault. I was advised to rebuild with -- enable-debug --enable-cassert, and so I did. The same query would now cause an assertion fail