On Fri, Jul 10, 2009 at 4:53 PM, James B. Byrne<byrnejb@xxxxxxxxxxxxx> wrote: > > On Fri, July 10, 2009 18:48, Scott Marlowe wrote: >> On Fri, Jul 10, 2009 at 2:13 PM, James B. >> Byrne<byrnejb@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
