Re: [SQL] postgres server crashes unexpectedly

2008-03-17 Thread Tom Lane
"Chadwick Horn" <[EMAIL PROTECTED]> writes: > PANIC: corrupted item pointer: offset = 0, size = 0 > LOG: autovacuum process (PID 3037) was terminated by signal 6 Hmm ... the only instances of that error text are in PageIndexTupleDelete and PageIndexMultiDelete, so we can fairly safely say that y

[SQL] postgres server crashes unexpectedly

2008-03-17 Thread Chadwick Horn
hi all, we've had a db to stop working for some reason and have searched through google to it's ends to no avail. we have reindexed the database and system database as tried to determine other things that would keep it from working... again, to no avail. this just started occuring about 2 week

Re: [SQL] Subselect strange behaviour - bug?

2008-03-17 Thread Mario Splivalo
Tom Lane wrote: Mario Splivalo <[EMAIL PROTECTED]> writes: And here is the 'problematic' query: melem=# select * from t2 where id1 in (select id1 from t1); I guess postgres should tell me that column name id1 is nonexistant in table t1. No, it shouldn't, because that's a perfectl