From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Vincent de Phily <vincent(dot)dephily(at)mobile-devices(dot)fr> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Receiving many more rows than expected |
Date: | 2014-05-09 15:01:47 |
Message-ID: | 536CEDDB.9060701@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 05/09/2014 01:45 AM, Vincent de Phily wrote:
> On Thursday 08 May 2014 16:56:25 Adrian Klaver wrote:
>> On 05/08/2014 03:11 PM, Vincent de Phily wrote:
>>> On Thursday 08 May 2014 06:30:39 Adrian Klaver wrote:
>>>> On 05/08/2014 04:09 AM, Vincent de Phily wrote:
>
> Before you grow suspicious of that conf_getint, the config is loaded once at
> program startup, and the overlarge results hapen together with normal results
> without having left the loop. Just in case I'm now logging the query string
> anyway; who knows...
As proof of concept that the value can change in the loop:
In [17]: l = [1, 2, 3, 4, 5]
In [18]: def getNumber():
return random.choice(l)
....:
In [19]: ct = 0
In [20]: while ct < 5:
s = 'Lucky number is %d' % (getNumber(),)
ct += 1
print s
....:
Lucky number is 5
Lucky number is 5
Lucky number is 4
Lucky number is 3
Lucky number is 2
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Vincent de Phily | 2014-05-09 15:04:12 | Re: Receiving many more rows than expected |
Previous Message | Adrian Klaver | 2014-05-09 13:52:33 | Re: Receiving many more rows than expected |