2010/6/24 Ravi Katkar <Ravi.Katkar@xxxxxxxxx>: > 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 schema I wish. > > > > Any ideas? PostgreSQL doesn't support global temporary tables yet. Regards Pavel Stehule > > > > Thanks in advance. > > > > > > -- Ravi Katkar -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general