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

Rules not supported by pg_pathman #130

Closed
@knizhnik

Description

The rule created for pathman partition doesn't work (but trigger works!).

Doesn't work:
CREATE RULE shardman_data_t_8_4_3_update AS ON UPDATE TO t_8 DO UPDATE shardman_data_t_8_4_3_fdw SET u = new.u, v = new.v WHERE (shardman_data_t_8_4_3_fdw.u = old.u);

Works:
create or replace function on_t8_update() returns trigger as $$ begin update shardman_data_t_8_4_3_fdw SET u = new.u, v = new.v WHERE (shardman_data_t_8_4_3_fdw.u = old.u); return new; end; $$ LANGUAGE plpgsql; create trigger on_t8_update_trigger after update on t_8 for each row execute procedure on_t8_update();

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 によって変換されたページ (->オリジナル) /