Re: temp tables ORACLE/PGSQL - Mailing list pgsql-general

From Neil Conway
Subject Re: temp tables ORACLE/PGSQL
Date
Msg-id 42730E0E.6090706@samurai.com
Whole thread Raw
In response to Re: temp tables ORACLE/PGSQL  (Dennis Sacks <dennis@illusions.com>)
List pgsql-general
Dennis Sacks wrote:
> The disadvantage is, you'll have to have some process for deleting
> old data from the table, as it will stay around and it will bite you
> when you get the same pg_backend_pid() again down the road.

Rather than use pg_backend_id(), why not just assign session IDs from a
sequence? You would still get the problem of stale session data so you'd
probably still want a periodic cleaner process, but you won't need to
worry about session ID collision.

-Neil

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Tuning queries inside a function
Next
From: mmiranda@americatel.com.sv
Date:
Subject: Re: Fatal error