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
On Monday, February 18, 2013 8:28 PM Rafael Martinez wrote:
> On 02/18/2013 03:41 PM, Amit Kapila wrote:
> [...]
> > Why you think this is wrong behavior, do you expect any time you
> > call pg_rotate_logfile(), it should truncate the file if
> > log_truncate_on_rotation is on? I think if y
On Mon, Feb 18, 2013 at 12:57 AM, Heikki Linnakangas <
hlinnakan...@vmware.com> wrote:
> On 16.02.2013 01:49, Daniel Farina wrote:
>
>> I guess that means Ubuntu (and probably Debian?) libpq-dev breaks
>> PG_VERSION_NUM for PGXS=1.
>>
>
> That obviously needs to be fixed in debian. Meanwhile, Maci
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/18/2013 03:41 PM, Amit Kapila wrote:
[...]
> Why you think this is wrong behavior, do you expect any time you
> call pg_rotate_logfile(), it should truncate the file if
> log_truncate_on_rotation is on? I think if you are expecting such
On Monday, February 18, 2013 5:42 PM sari thiele wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7890
> Logged by: Sari Thiele
> Email address: sari.thi...@usit.uio.no
> PostgreSQL version: 9.1.8
> Operating system: Red Hat Enterprise Linux Server
It is a wiki, so you can easily get an account and make the change
yourself. Thanks.
---
On Sun, Feb 17, 2013 at 07:14:00PM +, s...@spamik.cz wrote:
> The following bug has been logged on the website:
>
> Bug reference
The following bug has been logged on the website:
Bug reference: 7890
Logged by: Sari Thiele
Email address: sari.thi...@usit.uio.no
PostgreSQL version: 9.1.8
Operating system: Red Hat Enterprise Linux Server release 6.3
Description:
Hi,
I am trying to use the functio
On 16.02.2013 01:49, Daniel Farina wrote:
I guess that means Ubuntu (and probably Debian?) libpq-dev breaks
PG_VERSION_NUM for PGXS=1.
That obviously needs to be fixed in debian. Meanwhile, Maciek, I'd
suggest that you build PostgreSQL from sources, install it to some
temporary location, and
10 matches
Mail list logo
