On Oct 31, 2005, at 8:10 AM, Pier Fumagalli 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;

Should work, unless I messed up some minor bit of syntax.

Thanks Scott.

Ok, but I don't have permissions to try this out... The only thing I got is "readbugs" access! :-)

I need to set up a long running test here, then I can take a stab at it. On a backup, at first. (:

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