[GENERAL] Global temporary table - schema

2010-06-23 Thread Ravi Katkar
Hi List, When I have created Global temporary table its created under/in PG_temp_1 schema by default, When tried to specify the schema name explicitly its throwing below error ERROR: temporary tables cannot specify a schema name I wanted to create a Global temporary table in public or the

Re: [GENERAL] Global temporary table - schema

2010-06-23 Thread Pavel Stehule
2010/6/24 Ravi Katkar ravi.kat...@infor.com: Hi List, When I have created Global temporary table its created under/in PG_temp_1 schema by default, When tried to specify the schema name explicitly its throwing below error ERROR:  temporary tables cannot specify a schema name I