Skip to content

Constraint type not consistent when partitioning by int8 #33

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
digoal opened this issue Sep 27, 2016 · 1 comment
Closed

Constraint type not consistent when partitioning by int8 #33

digoal opened this issue Sep 27, 2016 · 1 comment

Comments

@digoal
Copy link

digoal commented Sep 27, 2016

postgres=# drop table test;
postgres=# create table test(id int8 primary key, info text, crt_time timestamp);
CREATE TABLE
postgres=# 
postgres=# select create_range_partitions('test'::regclass, 'id', 1::int8, 20000000::int8, 500::int8, false);
 create_range_partitions 
-------------------------
                     500
(1 row)
postgres=# select create_range_update_trigger('test'::regclass);
 create_range_update_trigger 
-----------------------------
 postgres.test_upd_trig_func
(1 row)
postgres=# select disable_parent('test'::regclass);
 disable_parent 
----------------

(1 row)
postgres=# explain select * from test where id=1;
WARNING:  Constant type in some check constraint does not match the partitioned column's type
ERROR:  Wrong constraint format for RANGE partition "test_1"
HINT:  pg_pathman will be disabled to allow you to resolve this issue
@funbringer funbringer changed the title bug, constraint type not consistent when i use int8 Constraint type not consistent when partitioning by int8 Sep 27, 2016
@funbringer
Copy link
Collaborator

Duplicate issue #30

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants