>>
>> - Original Message -
>> From: Peter Kroon
>> To: Pavel Stehule
>> Cc: Lou Picciano , Michael Paquier <
>> michael.paqu...@gmail.com>, pgsql-bugs@postgresql.org
>> Sent: Tue, 19 Feb 2013 16:50:25 - (UTC)
>> Subject: Re: [BUGS] Nes
f pgAdmin(?) or (various versions?) of libpq?
>
>
> Lou Picciano
>
> - Original Message -
> From: Peter Kroon
> To: Pavel Stehule
> Cc: Lou Picciano , Michael Paquier <
> michael.paqu...@gmail.com>, pgsql-bugs@postgresql.org
> Sent: Tue, 19 Feb 2013 16:50:25 - (UTC)
Sent: Tue, 19 Feb 2013 16:50:25 - (UTC)
Subject: Re: [BUGS] Nested xmlagg doesn't give a result 9.2.3
>you can test your queries from pgAdmin SQL executorI have already done so.
I'll look into the logs.
2013/2/19 Pavel Stehule
2013/2/19 Peter Kroon :
>>try to use pgAdminII
of readline
> >> >> buffering?
> >> >>
> >> >>
> >> >> - Original Message -
> >> >> From: Peter Kroon
> >> >> To: Lou Picciano
> >> >> Cc: Michael Paquier ,
> >> >> pgs
in the implementation(s) of readline
>> >> buffering?
>> >>
>> >>
>> >> - Original Message -----
>> >> From: Peter Kroon
>> >> To: Lou Picciano
>> >> Cc: Michael Paquier ,
>> >> pgsql-bugs@postgresql.or
> >> I wonder if there's a difference in the implementation(s) of readline
> >> buffering?
> >>
> >>
> >> - Original Message -
> >> From: Peter Kroon
> >> To: Lou Picciano
> >> Cc: Michael Paquier ,
> p
iginal Message -
>> From: Peter Kroon
>> To: Lou Picciano
>> Cc: Michael Paquier , pgsql-bugs@postgresql.org
>> Sent: Tue, 19 Feb 2013 15:28:47 - (UTC)
>> Subject: Re: [BUGS] Nested xmlagg doesn't give a result 9.2.3
>>
>> Exceeding length 4679
Lou Picciano
- Original Message -
From: Peter Kroon
Sent: Tue, 19 Feb 2013 11:52:37 -0000 (UTC)
Subject: Re: [BUGS] Nested xmlagg doesn't give a result 9.2.3
> When I'm on the sql machine via localhost or 192.168.1.100 I'm getting
> results.
I mean when I
resql.org
> Sent: Tue, 19 Feb 2013 15:28:47 -0000 (UTC)
> Subject: Re: [BUGS] Nested xmlagg doesn't give a result 9.2.3
>
> Exceeding length 4679 is a problem. Query results(length) equal or below
> this number succeed.
>
>
> 2013/2/19 Peter Kroon
>
>> When there
environment in some way, sometimes after
>>>> installing software.
>>>>
>>>> While the 'support libraries' issues above have no bearing on your
>>>> case, of course, I certainly don't know enough to know that the different
>>>&g
to know that the different
>>> versions of libpq don't present xmlagg output differently!
>>>
>>> The experts here will weigh in.
>>>
>>> Lou Picciano
>>>
>>>
>>> - Original Message -
>>> From: Peter
;> versions of libpq don't present xmlagg output differently!
>>
>> The experts here will weigh in.
>>
>> Lou Picciano
>>
>>
>> - Original Message -
>> From: Peter Kroon
>> Sent: Tue, 19 Feb 2013 11:52:37 - (UTC)
>>
of course, I certainly don't know enough to know that the different
> versions of libpq don't present xmlagg output differently!
>
> The experts here will weigh in.
>
> Lou Picciano
>
>
> ----- Original Message -
> From: Peter Kroon
> Sent: Tue, 19 Feb 2
will weigh in.
Lou Picciano
- Original Message -
From: Peter Kroon
Sent: Tue, 19 Feb 2013 11:52:37 - (UTC)
Subject: Re: [BUGS] Nested xmlagg doesn't give a result 9.2.3
> When I'm on the sql machine via localhost or 192.168.1.100 I'm getting
> results.
I mean
> 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 sur
>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
>
>
> On Tue, Feb 19, 2013 at 5:50 PM, Peter Kroon wrote:
>
On Tue, Feb 19, 2013 at 5:50 PM, Peter Kroon 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
Also no result with FROM __my_table LIMIT 1;
2013/2/19 Peter Kroon
> Mm..
> The problem only occurs on a specific table in my DB.
>
> --__my_table has 512 rows
>
> SELECT * FROM __my_table; --gives me result
>
> SELECT
> --xmlagg(
> xmlelement(name el_name,
> id
> )
> --)
> FROM __my_table;--g
Mm..
The problem only occurs on a specific table in my DB.
--__my_table has 512 rows
SELECT * FROM __my_table; --gives me result
SELECT
--xmlagg(
xmlelement(name el_name,
id
)
--)
FROM __my_table;--gives me result
When un-commenting the xmlagg I get no result. otherwise the output will
look lik
Hi Michael,
This should have been the expected result on both machines:
---
(1 row)
I've just rebooted "PostgreSQL 9.2.3 on x86_64-unknown-linux-gnu, compiled
by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit" and I'm gett
Hi,
With your query and such tables:
create table __table (id int);
insert into __table values (1),(2);
create table __table_to_table (id int, table_id int);
insert into __table_to_table values (1, 1),(2, 2);
I am getting consistent results with 9.2.1 and 9.2.3 on my Linux box, hence:
Query:
SELECT
xmlelement(name s_a,
xmlagg(
xmlelement(name s_b,
xmlattributes(
sq.id AS i
),
(SELECT
xmlagg(
xmlelement(name s_c,
xmlattributes(
su.id AS i
)
)
ORDER BY table_id,id
)
FROM __table_to_table AS su WHERE su.table_id=sq.id
)
)
)
)
FROM __table AS sq
No result given in: "PostgreSQL 9.2
22 matches
Mail list logo