Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Hi All,Please check the behavior of GTT having column with "SERIAL" datatype and column with default value as "SEQUENCE" as below:Session1:postgres=# create sequence gtt_c3_seq;CREATE SEQUENCEpostgres=# create global temporary table gtt(c1 int, c2 serial, c3 int default nextval('gtt_c3_seq') not null) on commit preserve rows;CREATE TABLE-- Structure of column c2 and c3 are similar:postgres=# \d+ gtt Table "public.gtt" Column | Type | Collation | Nullable | Default | Storage | Stats target | Description --------+---------+-----------+----------+---------------------------------+---------+--------------+------------- c1 | integer | | | | plain | | c2 | integer | | not null | nextval('gtt_c2_seq'::regclass) | plain | | c3 | integer | | not null | nextval('gtt_c3_seq'::regclass) | plain | | Access method: heapOptions: on_commit_delete_rows=falsepostgres=# insert into gtt select generate_series(1,3);INSERT 0 3postgres=# select * from gtt; c1 | c2 | c3 ----+----+---- 1 | 1 | 1 2 | 2 | 2 3 | 3 | 3(3 rows)Session2:postgres=# insert into gtt select generate_series(1,3);INSERT 0 3postgres=# select * from gtt; c1 | c2 | c3 ----+----+---- 1 | 1 | 4 2 | 2 | 5 3 | 3 | 6(3 rows)Kindly let me know, Is this behavior expected?
-- With Regards,Prabhat Kumar SahuEnterpriseDB: http://www.enterprisedb.com
With Regards,Prabhat Kumar SahuEnterpriseDB: http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: