Brian,
> My database for this project is about 40 tables. I don't know where the
> line is drawn on this list between postgres specific discussion and data
> model review.
I don't think that line exists.
> I am making a lot of changes right now including this archived/deleted
> indicator so I would welcome the opportunity to review my plans if it's
> acceptable, but I don't want to abuse the list.
Well, just show us the immediately relevant table(s); I'm not sure I'll read
an entire schema dump.
--
-Josh Berkus
"A developer of Very Little Brain"
Aglio Database Solutions
San Francisco