Hi durumdara, On Tuesday 07 July 2009 12:10:52 durumdara wrote: > Another question if I use only "SELECTS" can I get some Serialization > Error? No. > For example: > I need a report tool that can show the actual state of the business. > Because of I use value-dependent logic, I MUST use consistent state to > preserve the equality of many values (sums, counts, etc.). > So some (Read Committer) threads are update/delete/insert (sum modify) > rows, but this report tool only READ the tables, and only works for temp > tables. > Can I get some S. error from this transaction? > Or can I get some error from modifier threads if this (serializer > report) thread actually read the rows that they are want to modify? You can get errors between the writers but not between a writer and a reader. It probably would be a good idea to read the documentation about mvcc ( http://www.postgresql.org/docs/current/static/mvcc.html) to understand the possibilities/constraints better. Andres -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
