On Fri, Jul 10, 2009 at 4:53 PM, James B. Byrne<byrnejb@harte-lyne.ca> wrote:
>
> On Fri, July 10, 2009 18:48, Scott Marlowe wrote:
>> On Fri, Jul 10, 2009 at 2:13 PM, James B.
>> Byrne<byrnejb@harte-lyne.ca> wrote:
>>>
>>> 2009-07-10 15:59:17 EDT hll_theheart_test 216.185.71.24(49133)
>>> hll_theheart_db_admin : LOCATION: exec_simple_query,
>>> postgres.c:1105
>>> 2009-07-10 15:59:17 EDT hll_theheart_test 216.185.71.24(49133)
>>> hll_theheart_db_admin : LOG: 00000: duration: 0.782 ms
>>> statement:
>>> SELECT * FROM "currencies"
>>>
>>> The client program that receives this result reports that there
>>> are
>>> no rows returned. So where did they go"?
>>
>> Maybe there were no rows to return??
>>
>
> Clearly there are no rows. That is the problem. The question
> begging an answer is: where are the rows added in the immediately
> previous INSERTS?
Trigger or rule put them somewhere else or ignored them? Hard to say without
\d currencies