Yes, in acute intermittent porphyria, both pyrroles and porphyrins are excreted in the urine to an excessive degree.

Pyroluria (which can disturb the cognitive processes, and has even led to psychotic disorders). However, B6 deficiency is quite rare, and usually produced by interactions between medications and drugs (which can disrupt precursors to B6 formation, such as the amino acid, trytophan). Some medications on this list include oral contraceptives (but, even then, only a very few women are affected), certain antibiotics, and also alcohol.