problem trying to create a temp table
От | |
---|---|
Тема | problem trying to create a temp table |
Дата | |
Msg-id | 20120224062621.c760ddbd7c0975bc4b045766db7d895c.27a80495c2.wbe@email16.secureserver.net обсуждение исходный текст |
Ответы |
Re: problem trying to create a temp table
|
Список | pgsql-general |
<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>
В списке pgsql-general по дате отправления: