On Oct 31, 2005, at 8:08 AM, Scott Sanders wrote:

INSERT INTO longdescs (bug_id,who,bug_when,thetext) SELECT bug_id, 1,SYSDATE(),'Issue migrated to Jira: http://issues.apache.org/jira/ bugzillasearch.jsp?id=' || bug_id from bugs where product_id =8;

Hm... that gives me new comments, but empty ones.

Maybe I shouldn't have tried that on the live (albeit shut down) instance. Currently rolling back the dump, always a worth while exercise.

I'll puzzle some more on this on my home server.

S.

--
[EMAIL PROTECTED]              http://www.temme.net/sander/
PGP FP: 51B4 8727 466A 0BC3 69F4  B7B8 B2BE BC40 1529 24AF

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to