On 2/23/15 8:16 PM, Stephen Frost wrote: > * David G. Johnston (david.g.johnston@xxxxxxxxx) wrote: >> I take it that the table has to be permanent otherwise you would have >> suggested >> and unlogged temporary table as the target... > > A temporary table would have to be recreated each time and that'd be > less than ideal. You can use a single unlogged table which includes the > backend pid (which can be acquired through a function call) to keep > track of which user is logged in on a given backend at a given point in > time. It's not clear to me why creating a temp table per session would be less than ideal. I've certainly used session-scope temp tables to good effect a number of times. Transaction-scope would be another story of course. Am I missing something? -- - David Steele david@xxxxxxxxxxxxx
Attachment:
signature.asc
Description: OpenPGP digital signature
