Just to let everyone know that I haven't forgotten this. I just don't have
any time to spend on it.
The problem still occurs.
2013/2/20 Peter Kroon
> I've migrated everything to Linux and I'm able to continue my work.
> I'll get back on this next week.
>
>
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)
>you can test your queries from pgAdmin SQL executor
I have already done so.
I'll look into the logs.
2013/2/19 Pavel Stehule
> 2013/2/19 Peter Kroon :
> >>try to use pgAdminIII
> >
> > Could you be more specific?
>
> you can test your queries from pgAd
>try to use pgAdminIII
Could you be more specific?
2013/2/19 Pavel Stehule
> 2013/2/19 Peter Kroon :
> > Where can I check and/or alter this?
>
> try to use pgAdminIII
>
> Regards
>
> Pavel
>
> >
> >
> > 2013/2/19 Lou Picciano
> >>
Where can I check and/or alter this?
2013/2/19 Lou Picciano
> 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 , pgsql-bugs@postg
Exceeding length 4679 is a problem. Query results(length) equal or below
this number succeed.
2013/2/19 Peter Kroon
> When there are more then 88 rows in the table like 595 I can run the query
> with success when using: WHERE id BETWEEN 1 AND 88;
> Using LIMIT 88 fails -> ret
When there are more then 88 rows in the table like 595 I can run the query
with success when using: WHERE id BETWEEN 1 AND 88;
Using LIMIT 88 fails -> returns nothing
Selecting all fails as well.
2013/2/19 Peter Kroon
> When there are in __table_to_table more than 88 rows nothin
When there are in __table_to_table more than 88 rows nothing gets returned,
otherwise the query rolls out fine.
2013/2/19 Peter Kroon
> It appears to be a Windows issue only.
> I'll try to post some code.
>
>
> 2013/2/19 Lou Picciano
>
>> Seems your testing fro
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
n I get
no results.
Not sure what to think of this...
2013/2/19 Peter Kroon
> >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
>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, 201
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,
>
like:
"1"
"2"
"3"
etc
2013/2/19 Peter Kroon
> Hi Michael,
>
> This should have been the expected result on both machines:
> ---
>
> (1 row)
>
> I've just rebooted &
t" and I'm getting the
expected result.
Thanks for helping.
Best,
Peter Kroon
2013/2/19 Michael Paquier
> 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_i
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
Ignore, wrong list...
My apologies..
Best,
Peter
2012/11/23 Peter Kroon
> Is pgsql faster on linux?
> Currently I've made an installation on W7 and the converted queries are
> about 3 times slower then on mssql.
> There's still some optimization to do tho...but the
Is pgsql faster on linux?
Currently I've made an installation on W7 and the converted queries are
about 3 times slower then on mssql.
There's still some optimization to do tho...but the current results don't
look to good.
17 matches
Mail list logo
