Re: pl/pgsql Limits - Mailing list pgsql-sql

From Josh Berkus
Subject Re: pl/pgsql Limits
Date
Msg-id 3A6F0216.23896403@agliodbs.com
Whole thread Raw
In response to Re: pl/pgsql Limits  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Ian,

> That works, but when do you delete the records?

I delete the records:

a) When the user runs the report a second time, with different
parameters.

b) After the user exits, as part of a DB-wide clean-up procedure
(Function) that dumps everything with the user's session key.
                -Josh Berkus

-- 
______AGLIO DATABASE SOLUTIONS___________________________                                       Josh Berkus  Complete
informationtechnology      josh@agliodbs.com   and data management solutions       (415) 436-9166  for law firms, small
businesses      fax  436-0137   and non-profit organizations.       pager 338-4078                               San
Francisco


pgsql-sql by date:

Previous
From: Frank Joerdens
Date:
Subject: Making a foreign key chain - good idea or bad idea?
Next
From: Jie Liang
Date:
Subject: Re: How to change the ownership of the table?