[SQL] Error: out of memory in create table as

2006-08-03 Thread jason nordwick
I'm having memory problems. I needed to materialize a couple views (create table t as select * from v) to get acceptable performance from a small data storage system I'm building, but now I get out of memory issues on that statement. It is near the bottom of about a 40 line function, and it com

Re: [SQL] Change of data type

2006-08-07 Thread jason nordwick
On pg8, to change tab.col to type t: alter table tab alter column col type t so: alter table tab alter column material type text -j Judith wrote: Hello everybody, excuse me how can I change de data type of a field, I currently have: material character(30) but I now want the fi