[GENERAL] Serializable isolation level

2005-10-18 Thread sknipe
I need you expert opinions on the following statement. The primary reason I use serialized transactions is to avoid race conditions. One of postgresql's famed features is the MVCC (multi-version concurrency control) aka serialized transactions, which allows you to avoid using row/table level

[GENERAL] utf-8 and cultural sensitive sorting

2005-07-12 Thread sknipe
Our product will be storing its character data in utf-8 format (unicode encoding). What is the best way to achive cultural sensitive sorting using the utf-8 data? Is it possible have the locale apply to a connection? If so, is the cultural sorting support mature in PostgreSQL? What type o