<table align="center" bgcolor="#ffffff" border="0" cellpadding="0" cellspacing="0" style="empty-cells: show;"
width="100%"><tr><td;=";" </td="</td" align="left" background="cid:top@048ae683021f97453979805b18a66051" colspan="1"
height="72"style="text-align: left; background-repeat: no-repeat;"></td></tr><tr><td style="vertical-align: top;"><div
style="padding:5px; overflow-x: auto;"></div></td></tr></table><span style="font-family:Verdana; color:#000000;
font-size:10pt;"><div>ALL,</div><div> </div><div>Using9.1.2 on Windows 7 X64 for development.</div><div> </div><div>I'm
tryingto create a temporary table used to store session variables for each user when they login. I'm moving from SQL
Anywhereand they have a CREATE VARIABLE which does this, so I thought a temp table would work fine, especially since
eachuser will have their own copy.</div><div> </div><div>CREATE TEMP TABLE iss.sessionsettings<br />(<br /> VarName
charactervarying(20) NOT NULL,<br /> value character varying(128),<br /> CONSTRAINT pk_sessionsettings_varname
PRIMARYKEY (VarName )<br />)<br />WITH (<br /> OIDS=FALSE<br />);<br />ALTER TABLE iss.sessionsettings<br /> OWNER TO
postgres;</div><div> </div><div>WhenI try and run this I get the following error message.</div><div> </div><div>ERROR:
cannotcreate temporary relation in non-temporary schema</div><div><br />********** Error **********</div><div>ERROR:
cannotcreate temporary relation in non-temporary schema<br />SQL state: 42P16</div><div> </div><div>What do I need to
doto create temporary tables to the schema. I guess I could create a separate schema for temp tables if
needed.</div><div> </div><div> </div><div>BestRegards</div><div> </div><div>Michael Gould</div><div>Intermodal Software
Solutions,LLC</div><div>904-226-0978</div></span>