Hi all, Please check the below behavior for the "SERIAL" datatype.
postgres=# CREATE TABLE t1(c1 int, c2 serial); CREATE TABLE postgres=# insert into t1 values (generate_series(1,3)); INSERT 0 3 postgres=# insert into t1 values (generate_series(4,6)); INSERT 0 3 postgres=# select * from t1; c1 | c2 ----+---- 1 | 1 2 | 2 3 | 3 4 | 5 5 | 6 6 | 7 (6 rows) In this above case, the serial column "c2" is skipping the value "4" in select output. Is this an expected behavior? -- With Regards, Prabhat Kumar Sahu EnterpriseDB: http://www.enterprisedb.com
