[BUGS] BUG #14862: create table with missing sequence bug
| От | gezeala@gmail.com |
|---|---|
| Тема | [BUGS] BUG #14862: create table with missing sequence bug |
| Дата | |
| Msg-id | 20171019170424.1471.41843@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: [BUGS] BUG #14862: create table with missing sequence bug
|
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14862
Logged by: pgyayix
Email address: gezeala@gmail.com
PostgreSQL version: 9.4.9
Operating system: CentOS 7
Description:
--on a fresh db:
CREATE SCHEMA testschema;
--sequence is missing
--create table fails:
CREATE TABLE testschema.sometable1 ( col1 bigint DEFAULT
nextval('missingschema.missingsequence_id1'::regclass) NOT NULL, col2 text
);
--sequence is missing
--create table works fine:
CREATE TABLE testschema.sometable2 ( col1 bigint DEFAULT
nextval(('missingschema.missingsequence_id2'::text)::regclass) NOT NULL, col2 text
);
Only difference is sometable2 sequence definition has ::text::regclass.
Thanks.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
В списке pgsql-bugs по дате отправления: