> When I'm on the sql machine via localhost or 192.168.1.100 I'm getting results.
I mean when I'm physically behind the machine and login via pgadmin using localhost or 192.168.1.100 then I get results. When I'm on another machine and login via pgadmin(192.168.1.100) then I get no results. Not sure what to think of this... 2013/2/19 Peter Kroon <plakr...@gmail.com> > >Don't you have for example problems with the client application you use? > > Yes, with 1 table only. I'm not getting any results. > When I'm on the sql machine via localhost or 192.168.1.100 I'm getting > results. > > > 2013/2/19 Michael Paquier <michael.paqu...@gmail.com> > >> >> >> On Tue, Feb 19, 2013 at 5:50 PM, Peter Kroon <plakr...@gmail.com> wrote: >> >>> Also no result with FROM __my_table LIMIT 1; >>> >> I'm having correct results with PG 9.2 by using either xmlagg or >> xmlelement. >> For example: >> postgres=# SELECT xmlelement(name el_name, id) FROM __table LIMIT 1; >> xmlelement >> ---------------------- >> <el_name>1</el_name> >> Or: >> postgres=# SELECT xmlagg(xmlelement(name el_name, id)) FROM __table; >> xmlagg >> ------------------------------------------ >> >> <el_name>1</el_name><el_name>2</el_name> >> (1 row) >> >> Btw, such simple tests would have failed on the buildfarm for regression >> xml.sql, so this looks to be an error in your environment. >> Don't you have for example problems with the client application you use? >> -- >> Michael >> > >
