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
pgsql-novice by date
|Next:||From: sibusiso xolo||Date: 2002-07-23 20:18:29|
|Subject: help with failure to connect over a network|
|Previous:||From: Tom Lane||Date: 2002-07-23 15:30:46|
|Subject: Re: URGENT! pg_dump doesn't work! |