On 7/12/06, aurora <[EMAIL PROTECTED]> wrote:
Yes that helped!
reindex index users_email_address_text_key;
what version of postgres is this? there have been some bug fixes that
involved indexes on text columns.
wich locale are you using?
--
regards,
Jaime Casanova
"Programming today is a
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
mydb=# UPDATE users set email_address_text=email_address;
ERROR: invalid page header in block 6776 of relation
"users_email_address_text_key"
users_email_address_text_key sounds a lot like an index... is it an
index? if so, what happenned if you REINDEX the table or even DROP and
CREATE the in
On Jul 11, 2006, at 20:47 , aurora wrote:
There is no simple SQL to alter the type. So I use a series of SQLs to
create a new column, copy the data over and then replace the old
column with the
new.
What version of PostgreSQL are you running? In 8.0 and later you can
use ALTER TABLE ALTE
