On Friday, February 24, 2012 5:46:06 am mgo...@isstrucksoftware.net wrote:
> Andrew,
>
> That is acutally what the second run was supposed to be. I copied the
> original on instead of the second instance, but the results were the
> same.
Are you doing all this in the same session?:
test(5432)po
On 24/02/12 13:37, Andrew Gould wrote:
On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton wrote:
Temp tables get their own schema, and each session (connection) gets
its own temp schema. So - don't qualify them by schema.
Is that to avoid naming conflicts between simultaneous users?
Yes. I be
On 24/02/12 13:36, mgo...@isstrucksoftware.net wrote:
How do I access it. I just did that and when I try and access it with a
ERROR: relation "sessionsetting" does not exist
LINE 1: select * from "sessionsetting"
=> CREATE SCHEMA foo;
CREATE SCHEMA
=> CREATE TABLE foo.table1 (id int);
CREATE TA
es not exist
LINE 1: select * from "sessionsetting"
^
** Error **
ERROR: relation sessionsetting does not exist
SQL state: 42P01
Character: 15
Best Regards,
Michael Gould
Intermodal Software Solutions, LLC
904-226-0978
---- Original Message ----
Subject: Re: [
*
> ERROR: relation sessionsetting does not exist
> SQL state: 42P01
> Character: 15
>
> Best Regards,
> Michael Gould
> Intermodal Software Solutions, LLC
> 904-226-0978
>
>
>
> Original Message
> Subject: Re: [GENERAL] problem trying to create a tem
On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton wrote:
> On 24/02/12 13:26, mgo...@isstrucksoftware.net wrote:
>
>> ALL,
>> Using 9.1.2 on Windows 7 X64 for development.
>> I'm trying to create a temporary table used to store session variables
>> CREATE TEMP TABLE iss.sessionsettings
>
>
>> When
<<< text/html; charset="utf-8": Unrecognized >>>
<>
On 24/02/12 13:26, mgo...@isstrucksoftware.net wrote:
ALL,
Using 9.1.2 on Windows 7 X64 for development.
I'm trying to create a temporary table used to store session variables
CREATE TEMP TABLE iss.sessionsettings
When I try and run this I get the following error message.
ERROR: cannot creat
<<< text/html; charset="utf-8": Unrecognized >>>
<>
