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
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
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
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
-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
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
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:
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
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
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
10 matches
Mail list logo
