Skip to content

v11.5 create_range_partitions error whith uppercase table name #206

Closed
@dazhi1011

Description

@dazhi1011

Problem description

Its ok on v11.3 and v10.3,but there is an error on v11.5.
It seems because of the args passed from the pg ( parent_relid = PG_GETARG_OID(0) ).
Procedures to reproduce :

create table "Abc"("ID" int,"TE" timestamp not null);
insert into "Abc"("ID","TE") values (1,'2019-09-20 09:00');
select create_range_partitions('"Abc"','"TE"','2019-09-20'::date,'1 day'::interval);
insert into "Abc"("ID","TE") values (1,'2019-09-21 09:10');

ERROR:  relation "public.abc" does not exist
LINE 1: select public.create_single_range_partition('public.Abc', '2...
                                                    ^
QUERY:  select public.create_single_range_partition('public.Abc', '2019-09-21 00:00:00'::timestamp, '2019-09-22 00:00:00'::timestamp, 'public.Abc_2')

Environment

pg_pathman | 1.5 | public | Partitioning tool for PostgreSQL
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgis | 2.5.3 | public | PostGIS geometry, geography, and raster spatial types and functions

PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions