On Sun, 15 Aug 2004, Tom Lane wrote:
> Gavin Sherry <[EMAIL PROTECTED]> writes:
> > Jason Godden pointed out some weird savepoint behaviour on IRC and i've
> > narrowed this down to a simpler case.
>
> The answer turns out to be that GetSnapshotData is miscomputing snapshot
> xmin and RecentGlobal
Gavin Sherry <[EMAIL PROTECTED]> writes:
> Jason Godden pointed out some weird savepoint behaviour on IRC and i've
> narrowed this down to a simpler case.
The answer turns out to be that GetSnapshotData is miscomputing snapshot
xmin and RecentGlobalXmin when inside a subtransaction: it omits our o
I wrote:
> Can't reproduce it here --- I get the expected output,
Disregard that --- I had managed to omit the create index command while
copying and pasting.
Man, that is bizarre ... the index shouldn't make any difference at all...
regards, tom lane
---
Gavin Sherry <[EMAIL PROTECTED]> writes:
> Jason Godden pointed out some weird savepoint behaviour on IRC and i've
> narrowed this down to a simpler case.
Can't reproduce it here --- I get the expected output, on two different
machines (HPUX and RHL8). What are you testing on? Do you see the sam
Hi all,
Jason Godden pointed out some weird savepoint behaviour on IRC and i've
narrowed this down to a simpler case.
We see the following behaviour against HEAD:
template1=# create table foo(i int, j text);
CREATE TABLE
template1=# create unique index foo_idx on foo(i); -- not, creation of idx