Hi All, I have two tables: CREATE TABLE t1 (id int not null unique, info text); CREATE TABLE t2 (id int, grp int references t1(id), info text); Now, at certain point (both tables populated with tousends of records, and continuesly referenced by users), I need to adjust the value of an ID field of table T1. How can I do that? On the life system? Obvious solution like: UPDATE t1 SET id=239840 where id=9489; or in fact: UPDATE t1 SET id=id+10000 where id<1000; wouldn't work, regretably. Naturally I need to have column t2(grp) adjusted accordingly - within a single transaction. Asking this, because currently I've learned, that I can adjust the structure of my database (add/remove columns at will, reneme those, etc.), but I'm really stuck with 'looking so simple' task. Today I dump the database and perl-edit whatever's necesary and restore the database. But that's not a solution for life system. Is there a way to get this done? life/on-line? -- -R
