problem trying to create a temp table

ALL,





Using 9.1.2 on Windows 7 X64 for development.





I'm trying to create a temporary tableused to store session variables for each user when they login.I'm moving from SQL Anywhere and they have a CREATE VARIABLE which does this, so I thought a temp table would work fine, especially since each user will have their own copy.





CREATETEMP TABLE iss.sessionsettings

(

VarName character varying(20) NOT NULL,

value character varying(128),

CONSTRAINT pk_sessionsettings_varname PRIMARY KEY (VarName )

)

WITH (

OIDS=FALSE

);

ALTER TABLE iss.sessionsettings

OWNER TO postgres;





When I try and run this I get the following error message.





ERROR: cannot create temporary relation in non-temporary schema

********** Error **********


ERROR: cannot create temporary relation in non-temporary schema

SQL state: 42P16





What do I need to do to create temporary tables to the schema. I guess I could create a separate schema for temp tables if needed.








Best Regards





Michael Gould


Intermodal Software Solutions, LLC


904-226-0978