Re: [HACKERS] [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Andres Freund
On 2013-08-02 22:25:36 -0400, Alvaro Herrera wrote: > Andres Freund escribió: > > On 2013-08-02 18:17:43 -0400, Alvaro Herrera wrote: > > > Alvaro Herrera escribió: > > > > > > > As it turns out, I have a patched slru.c that adds a new function to > > > > verify whether a page exists on disk. I c

Re: [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Bruce Momjian
On Fri, Aug 2, 2013 at 11:20:37PM -0400, Jesse Denardo wrote: > Alvaro, > > I applied the patch and tried upgrading again, and everything seemed to work > as > expected. We are now up and running the beta! Yeah, great, thanks everyone! -- Bruce Momjian http://momjian.us Enterpris

Re: [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Jesse Denardo
Alvaro, I applied the patch and tried upgrading again, and everything seemed to work as expected. We are now up and running the beta! -- Jesse Denardo On Fri, Aug 2, 2013 at 10:25 PM, Alvaro Herrera wrote: > Andres Freund escribió: > > On 2013-08-02 18:17:43 -0400, Alvaro Herrera wrote: > > >

Re: [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Alvaro Herrera
Andres Freund escribió: > On 2013-08-02 18:17:43 -0400, Alvaro Herrera wrote: > > Alvaro Herrera escribió: > > > > > As it turns out, I have a patched slru.c that adds a new function to > > > verify whether a page exists on disk. I created this for the commit > > > timestamp module, for the BDR b

Re: [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Andres Freund
On 2013-08-02 18:17:43 -0400, Alvaro Herrera wrote: > Alvaro Herrera escribió: > > > As it turns out, I have a patched slru.c that adds a new function to > > verify whether a page exists on disk. I created this for the commit > > timestamp module, for the BDR branch, but I think it's what we need

Re: [BUGS] 9.3beta2: Failure to pg_upgrade

2013-08-02 Thread Alvaro Herrera
Alvaro Herrera escribió: > As it turns out, I have a patched slru.c that adds a new function to > verify whether a page exists on disk. I created this for the commit > timestamp module, for the BDR branch, but I think it's what we need > here. Here's a patch that should fix the problem. Jesse,

Re: [BUGS] BUG #8355: PL/Python 3 can't convert infinity to PostgreSQL's value

2013-08-02 Thread Tom Lane
I wrote: > ... further experimentation says that this doesn't work on my ancient > HPUX box; and you're complaining about Windows. So what we've got here > is a platform dependency in the behavior of strtod(). I don't think > we can promise to hide all such dependencies, but maybe it'd be a good

Re: [BUGS] BUG #8355: PL/Python 3 can't convert infinity to PostgreSQL's value

2013-08-02 Thread Tom Lane
gr...@yandex.ru writes: > PL/Python can't convert Python's float with infinity value to PostgreSQL's > float. > The reason is that Python's standard representation of infinity is 'inf' > ('Infinity' is accepted as well), but PostgreSQL's representation is > 'Infinity' only. Hmm, I was about to con

[BUGS] BUG #8355: PL/Python 3 can't convert infinity to PostgreSQL's value

2013-08-02 Thread grv87
The following bug has been logged on the website: Bug reference: 8355 Logged by: Basil Peace Email address: gr...@yandex.ru PostgreSQL version: 9.2.4 Operating system: Windows 7 x64 (PostgreSQL is x86), Python 3.2.5 Description: PL/Python can't convert Python's float

[BUGS] BUG #8354: stripped positions can generate nonzero rank in ts_rank_cd

2013-08-02 Thread alex
The following bug has been logged on the website: Bug reference: 8354 Logged by: Alex Hill Email address: a...@hill.net.au PostgreSQL version: 9.2.4 Operating system: OS X 10.8.4 Mountain Lion Description: Hi all, The docs for ts_rank_cd state: "This function requ

Re: [BUGS] BUG #8293: There are no methods to convert json scalar text to text in v9.3 beta2

2013-08-02 Thread Andrew Dunstan
On 08/02/2013 01:04 PM, Bruce Momjian wrote: On Wed, Jul 10, 2013 at 07:07:54PM +, jaroslav.pota...@gmail.com wrote: The following bug has been logged on the website: Bug reference: 8293 Logged by: Yaroslav Potapov Email address: jaroslav.pota...@gmail.com PostgreSQL ver

Re: [BUGS] BUG #8293: There are no methods to convert json scalar text to text in v9.3 beta2

2013-08-02 Thread Bruce Momjian
On Wed, Jul 10, 2013 at 07:07:54PM +, jaroslav.pota...@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 8293 > Logged by: Yaroslav Potapov > Email address: jaroslav.pota...@gmail.com > PostgreSQL version: Unsupported/Unknown > Operating

Re: [BUGS] BUG #8328: Unable to start postgresql on the Debian machine.

2013-08-02 Thread Kevin Grittner
"vijayakumar.su...@hp.com" wrote: > We are facing issue when trying to start postgresql on the Debian > machine. This is almost certainly not a bug; so it doesn't belong on this list.  pgsql-general would probably have been the best choice. Please pick a more appropriate list for any future que

Re: [BUGS] [GENERAL] Recovery_target_time misinterpreted?

2013-08-02 Thread Klaus Ita
No, it's super frustrating. While I do the recovery, it says it reaches a consistent recovery state, and i just cannot find a way how to convince pg to stop at that state: 2013-08-02 09:23:25 GMT DEBUG: postgres: PostmasterMain: initial environment dump: 2013-08-02 09:23:25 GMT DEBUG:

Re: [BUGS] BUG #8347: PANIC: heap_insert_redo: failed to add tuple when applying WAL

2013-08-02 Thread Daniel Farina
On Fri, Aug 2, 2013 at 12:51 AM, Klaus Ita wrote: > Isn't it a funny coincidence, that we also had a corruption of that > same/similar type? > > my disk was quite confidently not tampered. I am wondering: Does PG sign, or > checksum wal_files? Is the integrity of wal_files ensured by any mechanism

Re: [BUGS] BUG #8347: PANIC: heap_insert_redo: failed to add tuple when applying WAL

2013-08-02 Thread Klaus Ita
Isn't it a funny coincidence, that we also had a corruption of that same/similar type? my disk was quite confidently not tampered. I am wondering: Does PG sign, or checksum wal_files? Is the integrity of wal_files ensured by any mechanism? Because if it IS, then - in our case - it's a corruption c

Re: [BUGS] BUG #8352: Using UPPER in ON clause of JOIN

2013-08-02 Thread Vik Fearing
On 08/02/2013 01:48 AM, dy...@rbauction.com wrote: > The following bug has been logged on the website: > > Bug reference: 8352 > Logged by: Daisy > Email address: dy...@rbauction.com > PostgreSQL version: 9.2.4 > Operating system: Windows 7 > Description: > > When joini