Re: ERROR: out of shared memory

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

> On Wed, Nov 2, 2016 at 3:55 PM, Michael Moore <michaeljmoore(at)gmail(dot)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.