Re: [HACKERS] Savepoint weirdness

2004-08-15 Thread Gavin Sherry
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

Re: [HACKERS] Savepoint weirdness

2004-08-15 Thread 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. The answer turns out to be that GetSnapshotData is miscomputing snapshot xmin and RecentGlobalXmin when inside a subtransaction: it omits our o

Re: [HACKERS] Savepoint weirdness

2004-08-15 Thread Tom Lane
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 ---

Re: [HACKERS] Savepoint weirdness

2004-08-15 Thread 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

[HACKERS] Savepoint weirdness

2004-08-15 Thread Gavin Sherry
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