Forum OpenACS Q&A: Response to Postgres feature questions

Collapse
4: Response to Postgres feature questions (response to 1)
Posted by Roberto Mello on 10/15/01 02:23 AM
1. It's not that hard to have the functionality of materialized views in PG. It just takes a little more work, but it would work just fine.

2. PG 7.1 and below can't return cursors. As Don noted, 7.2 allows you to do that.

3. Don't know much in that area. Just one thing, just because something is not 'thread-safe' does not mean it's not production-worthy. Threads con be good (AOLserver) and can be bad, depending on the situation. PostgreSQL isn't threaded, for example. It's process-based.