lol @ "At least the NoSQL folks tend to be HONEST about their products not replacing the traditional RDBMS approach...."
More like, technically true, but contrary to the whole reason for doing what they're doing.
Nobody puts a lot of work into something "honestly" not intending to replace the thing it's replacing.
They say this to appease the people who point out that it doesn't do all the same things.
If I built a better alternative to a common item, you could bet your bottom dollar i would be very "honest" about it not replacing that common item. The last thing that statement would be is "honest." It's appeasement.
But in this case at least you are using PostgreSQL outside of anything even remotely purely relational. It is at least object-relational, and often key-value-id (like hstore) or document store (JSON or XML).
The power of PostgreSQL occurs from the power to ignore the relational model and take other approaches when it is helpful.