Hello,
Is altering a table from its own trigger possible? If not, how come?
For context, I am trying to attach a partition to a table using a trigger on that same table. Here is the error:
ERROR: cannot ALTER TABLE "tablename" because it is being used by active queries in this session
Any help would be greatly appreciated.
Thanks,