Re: [Postgres-xc-bugs] backup/restore problem using BARRIER

[Michael P. <mic...@gm...>]

I just checked this test case with vanilla PostgreSQL.
postgres=# CREATE TABLE tbl(I serial, j int);
NOTICE:  CREATE TABLE will create implicit sequence "tbl_i_seq" for serial
column "tbl.i"
CREATE TABLE
postgres=# INSERT INTO tbl(j) VALUES (generate_series(1,10));
INSERT 0 10
postgres=# INSERT INTO tbl(j) VALUES (generate_series(11,20));
INSERT 0 10
postgres=# select * from tbl;
 i  | j
----+----
  1 |  1
  2 |  2
  3 |  3
  4 |  4
  5 |  5
  6 |  6
  7 |  7
  8 |  8
  9 |  9
 10 | 10
 12 | 11
 13 | 12
 14 | 13
 15 | 14
 16 | 15
 17 | 16
 18 | 17
 19 | 18
 20 | 19
 21 | 20
(20 rows)
Conclusion, even in  the case of Postgres, the value 11 is missing.
So this is not a bug and process works OK.
-- 
Michael Paquier
http://michael.otacoo.com