Hi Bill,

I'm not sure what the query would be to ask for references to the table in Postgres, but I did a quick search for "spectradata" in the MS2 module's *.sql files.

The likely reference is the ms2.Spectra views defined in ms2-create.sql:

CREATE VIEW ms2.Spectra AS
    SELECT f.Run AS Run, sd.*
    FROM ms2.SpectraData sd INNER JOIN
        ms2.Fractions f ON sd.Fraction = f.Fraction;

Thanks,
Josh

Thanks for the quick response. It was in the views, cabig.spectra as well. Running a script through psql did not give the dependency tracing information in the error message. If I execute the drop command manually it gives me the rest of the story.

Bill