Hello, I'm playing with creating an auto vacuum daemon, but it is my first
time inside the pg source code and I'm a bit lost.
I have gotten as far as having a vacuum daemon created on postmaster startup.
It's just a fork from the postmaster, cribbed mostly from the stat collector
code.
Inside the main loop of the autovac daemon, I am trying to call vacuum() but I
get the following error:
FATAL: VACUUM cannot be executed from a function
I don't understand why it thinks I'm in a function, I believe the error is
being generated by this is vacuum.c:
/* Running VACUUM from a function would free the function context */if (vacstmt->vacuum &&
!MemoryContextContains(QueryContext,vacstmt)) elog(ERROR, "%s cannot be executed from a function", stmttype);
So, I assume it has something to do with the memory context that I'm in when I
call the vacuum command, so I have been playing with switching contexts and
such, but I have had no luck, obviously I don't really know what is going on
here.
The code snippet that is actually calling the vacuum looks like this:
{VacuumStmt *n = makeNode(VacuumStmt);n->vacuum = true;n->analyze = false;n->full = false;n->freeze = false;n->verbose
=false;n->relation = NULL;n->va_cols = NIL;vacuum(n);
}
Any help would be greatly appreciated.
Thanks,
Matt
