Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

В callback функцию не передается имя схемы #76

Closed
@DmitriyAr

Description

Здравствуйте!

Если я пытаюсь передаю в функцию set_init_callback имя таблицы из другой схемы, то получаю ошибку:

drop table pss.test cascade;
CREATE TABLE pss.test(a serial);
SELECT set_init_callback('pss.test', 'tablespace_callback');
SELECT create_range_partitions('pss.test', 'a', 1,100,1 ,false);

ERROR: relation "test_1" does not exist
CONTEXT: SQL statement "ALTER TABLE "test_1" SET TABLESPACE main_data_t3"
PL/pgSQL function tablespace_callback(jsonb) line 3 at EXECUTE
SQL statement "SELECT public.create_single_range_partition(
parent_relid,
start_value,
start_value + p_interval,
tablespace := public.get_tablespace(parent_relid))"
PL/pgSQL function create_range_partitions(regclass,text,anyelement,anyelement,integer,boolean) line 78 at PERFORM

insert into pss.test values(300);
ERROR: could not create new partitions for relation "test"

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

        AltStyle によって変換されたページ (->オリジナル) /