Thread: problem for o/p
sir,
i'am getting different o/p for the same program code as well as the data base is the same .twice the output is being printed on some machines whereas correct o/p on some.the program code is
create or replace function f() return int4 as'
c1 cursor for select empname from emp;
e1 emp.ename%type;
begin
open c1;
loop
fetch c1 into e1;
exit when not found;
raise notice ' 'emp name %' ', e1;
end loop;
close c1;
return 1;
end;
'language 'plpgsql';
Yahoo! India Matrimony: Find your partner now.
On Sat, Sep 10, 2005 at 12:11:52PM +0100, rajinder ruprai wrote: > i'am getting different o/p for the same program code as well as > the data base is the same .twice the output is being printed on > some machines whereas correct o/p on some.the program code is [...] > raise notice ' 'emp name %' ', e1; Where do the database server's logs go? You might be seeing duplicate output because the server's logs are sent to the same terminal as the client's output. BTW, this doesn't belong on pgsql-hackers. -- Michael Fuhr