Re: [HACKERS] select * from ..;vacuum crashes

> >You must enable Assert to see the crash.
>
> I saw the crash without assertion enabled? This is FreeBSD 2.2.6.
>
> >The cause may be because you are doing a vacuum INSIDE a transaction. I
> >think that also explains the psql -e thing, because that does both
> >commands in the same transaction.
> >
> >Perhaps we need to disable vacuum inside transactions. Vadim?

Turns out getting is being removed from pg_class. If you run the
script, without the final psql command, and go into ptest, and look do:

select oid, relname from pg_class

you see the table getting. If you then run the 'select * from getting'
and 'vacuum' you will see from the backtrace it is trying to update
statistics on the 'getting' table, but it is gone. If you go back into
ptest after the vacuum crash, 'getting' is gone from pg_class.

Looks like I may need help on this one. How does that happen?

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026