Re: problem trying to create a temp table

<table align=3D"center" style=3D"empty-cells: show;" bgcolor=3D"#ffffff" bo=
rder=3D"0" cellpadding=3D"0" cellspacing=3D"0" width=3D"100%"><td style=
=3D"text-align: left; background-repeat: no-repeat;" align=3D"left"; height=
=3D"72" colspan=3D"1" background=3D"cid:top@18707919e232053e6d9810030e7d0ce=
6"<div style=3D"padding: 5=
px; overflow-x: auto;"><span style=3D=
"font-family:Verdana; color:#000000; font-size:10pt;">How do I access =
it.  I just did that and when I try and access it with a
 
ERROR:  relation "sessionsetting" does not existLINE 1: selec=
t * from "sessionsetting"       &nbs=
p;            &=
nbsp; ^
********** Error **********
ERROR: relation "sessionsetting" does not existSQL state: 42P01<BR=
>Character: 15 
  or
ERROR: relation "sessionsetting" does not existLINE 1: select * fr=
om "sessionsetting"^
********** Error **********
ERROR: relation sessionsetting does not existSQL state: 42P01C=
haracter: 15
 
Best Regards,
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978
 
 
<BLOCKQUOTE style=3D"BORDER-LEFT: blue 2px solid; PADDING-LEFT: 8px; FONT-F=
AMILY: verdana; COLOR: black; MARGIN-LEFT: 8px; FONT-SIZE: 10pt" id=3Dreply=
Blockquote webmail=3D"1">
-------- Original Message --------Subject: Re:=
 [GENERAL] problem trying to create a temp tableFrom: Richard Huxton &l=
t;dev@archonet.com>Date: Fri=
, February 24, 2012 6:32 amTo: <a href=3D"mailto:mgould@isstrucksoftwar=
e.net">mgould@isstrucksoftware.netCc: "<a href=3D"mailto:pgsql-gene=
ral@postgresql.org">pgsql-general@postgresql.org" <<a href=3D"mailto=
:pgsql-general@postgresql.org">pgsql-general@postgresql.org>=
On 24/02/12 13:26, mgould@is=
strucksoftware.net wrote:> ALL,> Using 9.1.2 on Windo=
ws 7 X64 for development.> I'm trying to create a temporary table us=
ed to store session variables> CREATE TEMP TABLE iss.sessionsettings=
> When I try and run this I get the following error message.=
> ERROR: cannot create temporary relation in non-temporary schemaTem=
p tables get their own schema, and each session (connection) getsits ow=
n temp schema. So - don't qualify them by schema.-- Richard Hux=
tonArchonet Ltd<!-- wmL=
etter_tail_start -->=