[BUGS] Compile/Install(?) error PG 9.1.1 / Python3.2.2

2011-09-30 Thread Lou Picciano
After successful configure and build of PG 9.1.1 PYTHON=/usr/bin/python3.2 --with-python #make install does not place any python.library into $libdir. Reasonable results are reported in config.log - configure is finding the python3.2.2 binary. Server and all contrib are otherwise built AO

[BUGS] Compile bug: 9.1.1 with dtrace on OpenIndiana 151a (OpenSolaris 5.11)?

2011-09-30 Thread Lou Picciano
From: "Lou Picciano" Subject: Compile bug: 9.1.1 with dtrace on OpenIndiana (OpenSolaris)? dtrace: failed to compile script utils/probes.d: "/usr/lib/dtrace/mpi.d", line 70: failed to resolve type genunix`kthread_t * for identifier curthread: Module and program data models do not match Lo

Re: [BUGS] BUG #6235: Delete fails with ON DELETE rule on inherited table

2011-09-30 Thread Tom Lane
"Evan Martin" writes: > Defined a RULE that deletes from a child table whenever a parent table row > is deleted. If the parent (referencing) table INHERITS from another table > this rule doesn't work as intended, whether you delete from the base or > derived table. > If you delete from the base t

Re: [BUGS] BUG #6236: Query execution bug

2011-09-30 Thread Tom Lane
"Boris Matkov" writes: > INSERT INTO btest0 (id, name) VALUES ((SELECT DISTINCT id FROM btest0 WHERE > name = $1 LIMIT 1), $1) - was executed successfully > INSERT INTO btest0 (name,id) VALUES ($1, (SELECT DISTINCT id FROM btest0 > WHERE name = $1 LIMIT 1)) - I got error: > --

[BUGS] BUG #6236: Query execution bug

2011-09-30 Thread Boris Matkov
The following bug has been logged online: Bug reference: 6236 Logged by: Boris Matkov Email address: bor...@devart.com PostgreSQL version: 9.0.0.1 Operating system: Windows Description:Query execution bug Details: INSERT INTO btest0 (id, name) VALUES ((SELECT DISTIN

Re: FW: [BUGS] PostGre compatible to RHEL 6.1

2011-09-30 Thread Kevin Grittner
Yaamini Bist wrote: > Does that means it's supported as well on RHEL6.1 if we face issues > in future? Since this is not a bug, please post any further discussion of this on a more appropriate list, like pgsql-general. You should probably review these pages, and see if you still have questio

[BUGS] BUG #6235: Delete fails with ON DELETE rule on inherited table

2011-09-30 Thread Evan Martin
The following bug has been logged online: Bug reference: 6235 Logged by: Evan Martin Email address: postgre...@realityexists.net PostgreSQL version: 9.1.1 Operating system: Windows 7 x64 Description:Delete fails with ON DELETE rule on inherited table Details: Define

FW: [BUGS] PostGre compatible to RHEL 6.1

2011-09-30 Thread Yaamini Bist
Including all .. /// Cheers, Yaamini Bist "An optimist thinks that this is the best possible world, A pessimist fears that this is true":) From: Yaamini Bist Sent: Friday, September 30, 2011 11:11 AM To: 'robertmh...@gmail.com' Subject: FW: [BUGS] PostGre com

Re: [BUGS] BUG #6231: weird to_timestamp behaviour with out of range values

2011-09-30 Thread Henk Enting
On Thu, Sep 29, 2011 at 5:39 PM, Robert Haas wrote: > On Wed, Sep 28, 2011 at 11:43 AM, Tom Lane wrote: > > "Henk Enting" writes: > >> I would expect the to_timestamp function to return an error when I feed > it > >> out of range values, e.g. months > 13 and days > 31. Instead it seems to > add