Re: ERROR: out of shared memory

On Wed, Nov 2, 2016 at 4:06 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Wed, Nov 2, 2016 at 3:55 PM, Michael Moore <michaeljmoore@gmail.com> wrote:

David, 
I think that: ...

Method 1

create temporary table if not exists  temp_rslt of ypxportal2__fgetquestions  on commit drop;

is not functionally equivalent to 

Method 2

drop table if exists temp_rslt;

create temporary table  temp_rslt of ypxportal2__fgetquestions  on commit drop;

For example:

step 1. A calls B

step 2.     B creates temp_rslt table    (substitute Method 1 or Method 2 at this step) 

step 3.     B inserts one record into temp_rslt

step 4.     B returns, without error, to A -- note, no commit is done

step 5.     repeat #1

If, at step 2, we use Method 1, then  count(*) temp_rslt will never be more than 1.

If, at step 2, we use Method 2, then  count(*) temp_rslt will increment with each iteration of steps 1 thru 5.

Make sense?

​You missed the part where you immediately TRUNCATE the table after conditionally creating it...

​And no, Method 2 will reset since you are continually dropping it.

Method 1, without Truncate, will do the incrementing while Method 2 will not.​

David J.