ALL,
Using 9.1.2 on Windows 7 X64 for development.
I'm trying to create a temporary table used 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.
CREATE TEMP 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
