Re: [SQL] Unexpected SQL error for UPDATE

Yes that helped!  reindex index users_email_address_text_key;  UPDATE users set email_address_text=email_address;It kind of works now. Or at least it does not result in error. The UPDATE query is running for more than an hour and still hasn't return. This is inline  with what we have seen before th

[SQL] Unexpected SQL error for UPDATE

Originally I have a table like thiscreate table users ( userid integer not null,