From: | Russell Smith <mr-russ(at)pws(dot)com(dot)au> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Fuhr <mike(at)fuhr(dot)org> |
Subject: | Re: Statistics visibility in SERIALIZABLE transactions |
Date: | 2006-11-21 09:39:04 |
Message-ID: | 4562C938.20007@pws.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Josh Berkus wrote:
> Tom,
>
>
>> Try looking at a table that was ALTERed since
>> your transaction began.)
>>
>
> Shouldn't the transaction fail, then?
>
>
Neil Conway and I opened this VERY BIG can of worms a couple of years
ago on hackers.
I can't find the references to it in the archives. I think I need to go
back more than the start of 2005. And I can't remember how to do that.
It was in relation to CLUSTER on a table and how previous transactions
would not use the correct view of the table.
I recall something to do with issues relating to reading the catalog
before transaction startup and problems with needing a transaction to
use the catalog.
My memory of it is fuzzy. If Neil or Tom remember the discussion they
may be able to post a link.
Sorry if this wasn't much help.
Russell Smith
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2006-11-21 10:09:40 | Re: XA support (distributed transactions) |
Previous Message | Danny Milosavljevic | 2006-11-21 09:12:04 | Re: XA support (distributed transactions) |