Skip to content

A column with a trigger is not updated when a data change is made through the Data Output section #9598

@AdrienVH-c2c

Description

@AdrienVH-c2c

Hi !

I think that a column with a trigger is not updated when a data change is made through the Data Output section.

Here is how to reproduce it :

  • Create a table with several columns, including one "timestamp with time zone" column
  • Add a trigger to this table : CREATE TRIGGER trigger BEFORE INSERT OR UPDATE ON table FOR EACH ROW EXECUTE FUNCTION function()
  • Do an INSERT INTO TABLE ... with the "Query tool"
  • Do as SELECT * FROM table

Seen & expected behavior : the row can be seen in the "Data Output" section and the "timestamp with time zone" column is filled

  • Change the value of one the columns but not the "timestamp with time zone" one (through the "Data Output" section)
  • Press the "Save Data Changes" button

Seen behavior : only the changed column is up to date in the "Data Output" section

Expected behavior : the "timestamp with time zone" column should be up to date as well

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