Re: BUG #12679: temprary table not exists when close session and reconnect

Hi:

On Tue, Jan 27, 2015 at 12:02 PM, <ousema2003(at)yahoo(dot)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.