Is the column objects_ext.g_psfFluxSigma the uncertainty on the objects.g_psfFlux, i.e. the uncertainty on the latest observation in that filter?
Both Lasair schema and LSST Schema browser say: ‘Standard deviation of the distribution of g_psfFlux’
This is worded slightly ambiguously because it could either be the std of allg_psfFlux measurements or just the latest.
I am referring to Section 2.2.4 of NB tutorial 201.4 regarding difference-image photometry and the DP1 DiaObject table schema. In this context, g_psfFluxSigma represents the standard deviation of the distribution of g_psfFlux for a given object. In contrast, g_psfFluxErrMean is the standard error on the weighted mean of diaSource PSF fluxes. In case this isn’t the answer you were looking for, feel free to unmark the solution and we can keep looking into it.