It's toxic, but like everyone else said, it's safe once it dries. Once it dries, most of the toxic stuff evaporates and what's left is basically plastic.
The glue sold in the US for use on pipes has to pass FDA (or some other government acronym) approval, so I'd think it's pretty safe for your fish.