Re: [SQL] Problems with bulk update

2007-09-27 Thread Venelin Arnaudov
got error. "ERROR: column data_table.old_brand_id does not exist" It took me an eternity to realize that it is because of a missing entry in the mapping table. I have added the record and the update run correctly. Thank you very much Kindest regards, Venelin Arnaudov Richard Huxt

[SQL] Problems with bulk update

2007-09-27 Thread Venelin Arnaudov
field2_new=get_new_field2(field2_old); but it did not work :( It seems that the function is not executed for each record of the data_table. Kindest regards, Venelin Arnaudov ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster