Re: BR/

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