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,
Tamara