Hi Jerry,
I not as familiar with postgres as you are, because most of my experience has been with VFP and MySQL. Also I've taken a serious look at MSSQL which is a great product, but I think my clints would find it rather expensive relative to some their other options.
From what I've seen of postgres I am quite favorable impressed. It has transactions, triggers, sequences, and at least everything VFP has, so they match up well. However VFP could limit postgres as a front end in areas like its 256 field limit as opposed to postgres's 1600 fields allow by postgres. For me this is not a problem because I can't imagine a table with 1600 field. It would take half a day to find the field you need to do an update. Also it would take to long to complete a from that called for so many fields. Also, I think VFP has a 2 gig limit on its memo field where postgres blob field is much larger. However there may be work arounds for these areas where VFP and prosgres don't exact match.