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.