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