I'm trying to do something pretty basic per the documentation using plpython triggers. When I change the "cfgCmd" field in the SysConfig table below, the trigger works fine and if I have a null function that does nothing but write to the pipe, that all works fine. The trouble is when the function attemts to read from the SysConfig database, "cfgCmd" field which tells the function what to do. When I write a value to the SysConfig table, cfgCmd field, the server log says:
ERROR: plppython: function "send_ctl_msg" failed
DETAIL: exceptions.KeyError: 'cfgCmd'
What's a key error? I can't find any documentation on it? Also, when I try to reference TD["old"][<column name>] this gives me an error too. Does this have something to do with the untrusted language part or am I doing something wrong? Thanks much for any help,
Curt
Here is the trigger function:
-- Send Control Message (send_ctl_msg)
CREATE FUNCTION send_ctl_msg() RETURNS trigger AS $$
import os
import os.path
pipe_loc = TD["args"][0]
old = TD["old"]
new = TD["new"]
rv = plpy.execute("SELECT * from ucfg.SysConfig",1)
ens_cmd = rv[0]["cfgCmd"]
plpy.log(cmd)
if os.path.exists(pipe_loc):
pipeout = open(pipe_loc,"w")
print >>pipeout,ens_cmd
else:
plpy.error("Build System cmd FIFO not found. Make sure VMD is running")
$$ LANGUAGE plpythonu;
Here is the table it's trying to access:
CREATE TABLE ucfg.SysConfig (
-- System map selection and running
startupSysMapName VARCHAR(64) REFERENCES ucfg.SysMaps(sysMapName),
-- System map to load and run at system boot.
activeSysMapName VARCHAR(64) REFERENCES ucfg.SysMaps(sysMapName),
-- System map that is currently loaded.
checkSysMapName VARCHAR(64) REFERENCES ucfg.SysMaps(sysMapName),
-- System map to be checked to see if it builds properly
cfgCmd VARCHAR(16), -- ENS configuration control command
-- "NONE", "CHECK", "LOAD", "RUN", "STOP"
);
Here is the trigger function:
CREATE TRIGGER tr_exec
AFTER UPDATE ON ucfg.SysConfig for EACH ROW
EXECUTE PROCEDURE public.send_ctl_msg("/var/ens/cmdfifo");