large table and temp space.

I have a 10 million row table that I want to prune down and then create a
table from this pruned data.  I was using "select col1 into newtable from
oldtable where col1 not like '%somevar'  ;     but this creates an error
"ERROR:  ltsWriteBlock: failed to write block 3617 of temporary file
                Perhaps out of disk space?"   I think I have plenty of disk
left, but I don't know how to let postgres know I have more space.

The second problem is that I have a column that is text.  I need to take
that text and turn it into a recognizable date.  It is currently in UNIX
time format (i.e.1025510400.814 ).



Mark P. Molenda <<...OLE_Obj...>>
Senior Information Specialist
NYSC