"Thalis A. Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> writes:> The query executes fine when ran by itself. Why should it crash if ran twice?
Could you have run the system out of swap space?
regards, tom lane