Re: [BUGS] BUG #5841: rank()+1 fails, 1+rank() succeeds

2011-01-21 Thread Robert Haas
On Tue, Jan 18, 2011 at 6:19 AM, wrote: > Thanks for clarifying. I've submitted a note on the interactive version of > the docs, and attached a small patch to make explicit that a window function > is followed _immediately_ by an OVER clause, as the syntax[1] indicates. I've committed the first

[BUGS] Bug in italian help of "pg_dumpall"

2011-01-21 Thread Giacomo Petillo
Hi, in the help of "pg_dumpall" pops up this error: Opzioni di connessione: -h, --host=NOMEHOST host server di database o directory socket -l, --database=NOMEDBpreimpostazione database alternativo *p, --port=PORTA numero porta del server di database U, --username=NOME

Re: [BUGS] Psql malloc error on Git master

2011-01-21 Thread Thom Brown
On 21 January 2011 14:55, Bernd Helmle wrote: > > > --On 20. Januar 2011 21:56:44 + Thom Brown wrote: > >>> Known bug in OSX's libedit.  Use readline instead. >>> >>> http://archives.postgresql.org/pgsql-bugs/2010-04/msg00127.php >>> >>>                        regards, tom lane >> >> How do I

Re: [BUGS] Regular issues faced on postgres 8.1

2011-01-21 Thread David Fetter
On Fri, Jan 21, 2011 at 12:37:19PM +0530, Kunwar Anjani Tyagi wrote: > Server Details : > > Environment : RHEL 4 > Postgres Version :Postgres 8.1 While you would normally need to supply the full version number, as in 8.1.24, you've supplied enough info with the major version, 8.1, which just went

Re: [BUGS] Regular issues faced on postgres 8.1

2011-01-21 Thread Robert Haas
On Fri, Jan 21, 2011 at 2:07 AM, Kunwar Anjani Tyagi wrote: > Missing chunk number 0 for toast value : This case is generated due to > corruption of toast table of a particular table.Many times reindexing the > toast table solves the problem. > Cannot insert a duplicate key into unique index : On

Re: [BUGS] Psql malloc error on Git master

2011-01-21 Thread Bernd Helmle
--On 20. Januar 2011 21:56:44 + Thom Brown wrote: Known bug in OSX's libedit.  Use readline instead. http://archives.postgresql.org/pgsql-bugs/2010-04/msg00127.php                        regards, tom lane How do I force readline? I'm not using --with-libedit-preferred or --without-re

[BUGS] Regular issues faced on postgres 8.1

2011-01-21 Thread Kunwar Anjani Tyagi
Server Details : Environment : RHEL 4 Postgres Version :Postgres 8.1 1.. Missing chunk number 0 for toast value : This case is generated due to corruption of toast table of a particular table.Many times reindexing the toast table solves the problem. 2.. Cannot insert a duplicate key into un