pg-mem icon indicating copy to clipboard operation
pg-mem copied to clipboard

🚩 Support "CREATE TRIGGER" & "CREATE AGGREGATE" statements

Open oguimbal opened this issue 4 years ago • 2 comments

Supporting CREATE TRIGGER is somehow related to the possibility of supporting CREATE FUNCTION statements, which is tracked by https://github.com/oguimbal/pg-mem/issues/42

That said, supporting triggers for functions declared as custom functions should also be possible, and simpler.

... it must just be decided how to let function implementation access caller context:

  • new/old record versions
  • the current transaction (all sub-requests must be performed in the same outer transaction)

Maybe via some static functions ?

nb: Beware of reentrant calls... must check how this is handled in pg.

oguimbal avatar Jan 18 '21 18:01 oguimbal

Hello, any update on this?

tiennguyen1203 avatar Jul 31 '24 17:07 tiennguyen1203

Hellon any news ? is there an option to just "ignore" these no suported features ?

ilianAZZ avatar Aug 20 '25 23:08 ilianAZZ