Re: [BUGS] BUG #7498: Questionable interval parsing when in the form 'n m days'

On Wed, Aug 15, 2012 at 5:19 PM, Tom Lane wrote: > dan...@heroku.com writes: >> select '1 5 hours'::interval = '1 day 5 hours'::interval; >> ?column? >> -- >> t >> (1 row) > >> I think that the first spelling, a unit-less '1', should not be accepted. > > Not sure I agree. The syntax '1

Re: [BUGS] ProblemWithCharsOSX

=?ISO-8859-1?B?QW5nZWwgWvrxaWdh?= writes: > I'm a PostgreSQL user in the linux world but at the office there is a Mac > computer and I have a problem with postgres in it. > The problem is when I use characters with tildes in spanish like in the > follow word "países". > The next is ilustrates my

Re: [BUGS] BUG #7498: Questionable interval parsing when in the form 'n m days'

dan...@heroku.com writes: > select '1 5 hours'::interval = '1 day 5 hours'::interval; > ?column? > -- > t > (1 row) > I think that the first spelling, a unit-less '1', should not be accepted. Not sure I agree. The syntax '1 05:00' is required by spec to mean '1 day 5 hours 0 minutes'

Re: [BUGS] Possible Bug in 9.2beta3

Adam Mackler writes: > On Wed, Aug 15, 2012 at 12:53 PM, Tom Lane wrote: >> Right offhand I'm inclined to think that the reference to "iter" >> inside the first sub-WITH ought to be disallowed. I don't recall >> the exact rules about where a recursive reference can appear, but >> it sure doesn't

[BUGS] BUG #7498: Questionable interval parsing when in the form 'n m days'

The following bug has been logged on the website: Bug reference: 7498 Logged by: Daniel Farina Email address: dan...@heroku.com PostgreSQL version: 9.1.4 Operating system: Ubuntu 12.04 Description: This is an expression that should probably have an error and not evalu

Re: [BUGS] psql doesn't reuse -p after backend fail

On Wed, Sep 14, 2011 at 10:52:50PM -0500, Robert Haas wrote: > On Thu, Sep 8, 2011 at 5:09 AM, Peter Eisentraut wrote: > > On tis, 2011-09-06 at 17:12 +0200, hubert depesz lubaczewski wrote: > >> On Mon, Sep 05, 2011 at 02:27:23PM -0400, Tom Lane wrote: > >> > It's not just the port, it's all the

Re: [BUGS] Possible Bug in 9.2beta3

Are you asking me or the other experts? I had not even heard of a common table expression a few weeks ago, so I doubt I'm qualified to opine what ought to be possible; I just know what I'm trying to do. Basically I've got a recursive CTE with rows, some of which have information that I want to be

Re: [BUGS] BUG #7494: WAL replay speed depends heavily on the shared_buffers size

On 08/15/12 9:02 AM, Valentine Gogichashvili wrote: On Wed, Aug 15, 2012 at 3:40 PM, John R Pierce > wrote: On 08/15/12 6:36 AM, Bruce Momjian wrote: We warn against making shared buffers > 8GB, and this is perhaps another good reason.

Re: [BUGS] BUG #6178: date_trunc : interval units "week" not supported contradicts documentation

On Thu, Aug 25, 2011 at 07:05:34PM +, Noah Hamerslough wrote: > > The following bug has been logged online: > > Bug reference: 6178 > Logged by: Noah Hamerslough > Email address: n...@pcc.com > PostgreSQL version: 8.4 > Operating system: Windows Vista > Description:

[BUGS] BUG #7497: Excessive toast bloat after standby promotion

The following bug has been logged on the website: Bug reference: 7497 Logged by: Daniel Farina Email address: dan...@heroku.com PostgreSQL version: 9.0.7 Operating system: Ubuntu 10.04 Description: We have an interesting case of an application that is non-trivial but

Re: [BUGS] BUG #7495: chosen wrong index

"Kevin Grittner" wrote: <> p...@elbrief.de> wrote: > >> insert into bla ( a , b ) >> select a , a >> from generate_series( 1 , 100 ) as a ( a ) ; > >> explain analyze select * from bla >> where b > 99 order by a limit 10 ; >> [uses index on b and has a long run time] > > The

Re: [BUGS] Possible Bug in 9.2beta3

Adam Mackler writes: > WITH RECURSIVE > tab(id_key,link) AS ( VALUES (1,17), (2,17), (3,17), (4,17), (6,17), (5,17) ), > iter (id_key, row_type, link) AS ( > SELECT 0, 'base', 17 > UNION( > WITH remaining(id_key, row_type, link, min) AS ( > SELECT tab.id_key, 'true'::text, iter.lin

Re: [BUGS] BUG #7494: WAL replay speed depends heavily on the shared_buffers size

Hallo John, On Wed, Aug 15, 2012 at 3:40 PM, John R Pierce wrote: > On 08/15/12 6:36 AM, Bruce Momjian wrote: > >> We warn against making shared buffers > 8GB, and this is perhaps another >> good reason. >> > > I generally keep it at no more than 2gb as I've never found any > performance improve

Re: [BUGS] BUG #6165: documentation bug in plpgsql-declarations.html and plpgsql-statements.html (or plpgsql parser bug)

On Mon, Aug 22, 2011 at 04:17:04PM -0400, Tom Lane wrote: > Robert Haas writes: > > On Wed, Aug 17, 2011 at 1:21 AM, raf wrote: > >> so, there is either a plpgsql parser bug that treats the sql equality > >> operator as the plpgsql assignment operator, or "=" is an undocumented > >> alternative t

Re: [BUGS] pg_dump dependency loop with extension containing its own schema

On 15 August 2012 16:30, Tom Lane wrote: > Thom Brown writes: >> On 12 August 2012 08:17, Thom Brown wrote: >>> On 12 August 2012 01:06, Tom Lane wrote: ISTM we ought to disallow that ... either the schema is inside the extension, or vice versa, it's not sensible to say both. > >>> Pr

Re: [BUGS] BUG #7494: WAL replay speed depends heavily on the shared_buffers size

Hallo Andreas, > Could you try to get a profile of that 100% cpu time? > > Yes I will try to do it. -- Valentine

Re: [BUGS] pg_dump dependency loop with extension containing its own schema

Thom Brown writes: > On 12 August 2012 08:17, Thom Brown wrote: >> On 12 August 2012 01:06, Tom Lane wrote: >>> ISTM we ought to disallow that ... either the schema is inside the >>> extension, or vice versa, it's not sensible to say both. >> Precisely. > Suggested changes attached. (not reall

Re: [BUGS] BUG #6162: initdb : Windows username isn't escaped

On Sun, Aug 14, 2011 at 11:25:22AM +, Emmanuel Guyot wrote: > > The following bug has been logged online: > > Bug reference: 6162 > Logged by: Emmanuel Guyot > Email address: emmanuel.gu...@gmail.com > PostgreSQL version: 8.2.3 > Operating system: Windows 7 > Description:

[BUGS] ProblemWithCharsOSX

Hi there, I'm a PostgreSQL user in the linux world but at the office there is a Mac computer and I have a problem with postgres in it. The problem is when I use characters with tildes in spanish like in the follow word "países". The next is ilustrates my problem: test=# SHOW SERVER_ENCODING; se

Re: [BUGS] BUG #7495: chosen wrong index

wrote: > insert into bla ( a , b ) > select a , a > from generate_series( 1 , 100 ) as a ( a ) ; > explain analyze select * from bla > where b > 99 order by a limit 10 ; > [uses index on b and has a long run time] The problem is that PostgreSQL doesn't have any sense of the c

[BUGS] BUG #7495: chosen wrong index

The following bug has been logged on the website: Bug reference: 7495 Logged by: Andreas Email address: p...@elbrief.de PostgreSQL version: 9.1.4 Operating system: Debian Linux Description: Hello. create table bla ( a int , b int ) ; insert into bla ( a , b ) select

Re: [BUGS] BUG #7494: WAL replay speed depends heavily on the shared_buffers size

Hi, On Wednesday, August 15, 2012 12:10:42 PM val...@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 7494 > Logged by: Valentine Gogichashvili > Email address: val...@gmail.com > PostgreSQL version: 9.0.7 > Operating system: Linux versi

Re: [BUGS] BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows

On Wed, Aug 15, 2012 at 2:37 PM, Rikard Pavelic wrote: > On 15.8.2012. 3:54, Craig Ringer wrote: >> On 08/14/2012 11:42 PM, Rikard Pavelic wrote: >>> On 8.8.2012. 13:30, Craig Ringer wrote: On 08/08/2012 06:24 PM, rikard.pave...@zg.htnet.hr wrote: > The following bug has been logged on th

Re: [BUGS] BUG #7494: WAL replay speed depends heavily on the shared_buffers size

On 08/15/12 6:36 AM, Bruce Momjian wrote: We warn against making shared buffers > 8GB, and this is perhaps another good reason. I generally keep it at no more than 2gb as I've never found any performance improvements going higher, on systems with 48gb ram, and had more than a few performance

Re: [BUGS] BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows

On 15.8.2012. 3:54, Craig Ringer wrote: > On 08/14/2012 11:42 PM, Rikard Pavelic wrote: >> On 8.8.2012. 13:30, Craig Ringer wrote: >>> On 08/08/2012 06:24 PM, rikard.pave...@zg.htnet.hr wrote: The following bug has been logged on the website: Bug reference: 7485 Logged by:

Re: [BUGS] BUG #7494: WAL replay speed depends heavily on the shared_buffers size

On Wed, Aug 15, 2012 at 10:10:42AM +, val...@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 7494 > Logged by: Valentine Gogichashvili > Email address: val...@gmail.com > PostgreSQL version: 9.0.7 > Operating system: Linux version 2.

Re: [BUGS] pg_dump dependency loop with extension containing its own schema

On 12 August 2012 08:17, Thom Brown wrote: > On 12 August 2012 01:06, Tom Lane wrote: >> Thom Brown writes: >>> I'm getting a dependency loop issue with pg_dump when adding a schema >>> to an extension where the schema being added is the same as the one >>> containing the extension. >> >>> CREAT

[BUGS] BUG #7494: WAL replay speed depends heavily on the shared_buffers size

The following bug has been logged on the website: Bug reference: 7494 Logged by: Valentine Gogichashvili Email address: val...@gmail.com PostgreSQL version: 9.0.7 Operating system: Linux version 2.6.32-5-amd64 (Debian 2.6.32-41) Description: We are experiencing strang