[GENERAL] Function Problem

[Jamie Deppeler]

Problem
I am trying to store value in a TEMPORARY table and I am getting the 
following error

ERROR: relation with OID 51533 does not exist
Trigger
CREATE TRIGGER "createtemporytable" AFTER INSERT
ON "component" FOR EACH ROW
EXECUTE PROCEDURE "createtemp"();
Function
begin
  CREATE temporary TABLE primarykey
  (
   componentpk Integer,
   plannerpk Integer,
   materialplanpk Integer,
   resourceplanpk Integer
  );
  INSERT INTO primarykey(componentpk)
  VALUES (new."primary");
  UPDATE component
    set "notes" = 'Updated'
  where component."primary" = primarykey.componentpk;
end
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly