Re: [h2] Questions about MVCC

2013-11-24 Thread cowwoc
Hi Thomas, Thanks for the reply. On 21/11/2013 6:43 AM, Thomas Mueller wrote: Does H2 implement Serializable Snapshot Currently not, and I didn't plan to support it. In theory, it could be supported with the MVStore, but I don't currently think it's very important. How does SERIALIZABLE

Re: [h2] Questions about MVCC

2013-11-24 Thread Thomas Mueller
Hi, How does SERIALIZABLE isolation in MVCC mode compare to SERIALIZABLE_SNAPSHOT? Aren't they the same thing? I can only refer to Google, which found this: http://blogs.msdn.com/b/craigfr/archive/2007/05/16/serializable-vs-snapshot-isolation-level.aspx Regards, Thomas On Sun, Nov 24, 2013

Re: [h2] Questions about MVCC

2013-11-24 Thread cowwoc
Hi Thomas, It was my understanding that SERIALIZABLE isolation in MVCC mode is supposed to behave like SERIALIZABLE_SNAPSHOT. At least, that's the case for Postgres. If SERIALIZABLE behaves the way you mention in MVCC mode, what is the difference if MVCC mode is on or off? It doesn't sound

Re: [h2] Questions about MVCC

2013-11-24 Thread Ryan How
This is interesting :) Does MVCC even support different isolation modes?. I thought it was it's own isolation mode? The different isolation modes don't seem to make sense in an MVCC context? Thanks, Ryan On 24/11/2013 11:50 PM, cowwoc wrote: Hi Thomas, It was my understanding that

Re: [h2] DATABASE_TO_UPPER=false and PgServer

2013-11-24 Thread Noel Grandin
Hi Thanks for your patch. I'm not sure about the change to only return PUBLIC tables, but the rest looks fine. Can we get a license statement? http://h2database.com/html/build.html#providing_patches The catalog can only be installed when the first connection arrives because it's only at