Thread: 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 ?

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.