BUG #12679: temprary table not exists when close session and reconnect
The following bug has been logged on the website:
Bug reference: 12679
Logged by: temprary table not exists when close session and reconnect
Email address: ousema2003@yahoo.fr
PostgreSQL version: 9.2.0
Operating system: linux x86 64 / centos 5.9
Description:
in fact i created a temprary table as floowing :
create temp table a_temp(name varchar);
then insert some rows and later when i reconnect with psql program,
the temp table i created earlier, doesn't exists .
please advice how can i deal with this issue ?
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Hi:
On Tue, Jan 27, 2015 at 12:02 PM, <ousema2003@yahoo.fr> wrote:
...
Logged by: temprary table not exists when close session and
reconnect
...
in fact i created a temprary table as floowing :
create temp table a_temp(name varchar);
then insert some rows and later when i reconnect with psql program,
the temp table i created earlier, doesn't exists .
please advice how can i deal with this issue ?
Seems to be working, try ReadingTFM:
http://www.postgresql.org/docs/9.2/static/sql-createtable.html
"TEMPORARY or TEMP
If specified, the table is created as a temporary table. Temporary tables
are automatically dropped at the end of a session, or optionally at the end
of the current transaction...
"
disconnecting/reconnecting puts you into different sesions, table is
dropped. This is what temporary tables are for.
Francisco Olarte.