You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
select
create_range_partitions('part_test'::regclass, 'crt_time', '2016-10-25 00:00:00'::timestamp without time zone, interval '1 year', 24, false);
get error during create range partitions.
ERROR: function create_range_partitions(regclass, unknown, timestamp without time zone, interval, integer, boolean) does not exist
LINE 2: create_range_partitions('part_test'::regclass, 'crt_time', '...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Environment
postgres 9.5
ubuntu18.04
mydb=# \dx
List of installed extensions
Name | Version | Schema | Description
------------+---------+------------+----------------------------------
pg_pathman | 1.5 | public | Partitioning tool for PostgreSQL
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
Table "public.part_test"
Column | Type | Modifiers | Storage | Stats target | Description
----------+-----------------------------+-----------+----------+--------------+-------------
id | integer | not null | plain | |
info | text | | extended | |
crt_time | timestamp without time zone | not null | plain | |
The text was updated successfully, but these errors were encountered:
CREATE EXTENSION pg_pathman;
create table part_test(id int, info text, crt_time timestamp without time zone not null);
select create_range_partitions('part_test'::regclass, 'crt_time', '2016-10-25 00:00:00'::timestamp without time zone, interval '1 year', 24, false);
works for me on 9.5. Probably you have wrong search_path?
Problem description
select
create_range_partitions('part_test'::regclass, 'crt_time', '2016-10-25 00:00:00'::timestamp without time zone, interval '1 year', 24, false);
get error during create range partitions.
Environment
postgres 9.5
ubuntu18.04
The text was updated successfully, but these errors were encountered: