Re: [BUGS] BUG #8049: Incorrect results when using ORDER BY and query planner options

2013-04-25 Thread Andres Freund
On 2013-04-25 16:27:47 +0800, Jov wrote: > I can reproduce on 9.2.4 too. > > plan, but also wrong plan. I think it is a terrible bug. * Just in case you missed it, there's ongoing work to fix it. For some explanations see: http://www.postgresql.org/message-id/6546.1365701...@sss.pgh.pa.us Gree

[BUGS] BUG #8115: Increased session memory usage after pg_upgrade

2013-04-25 Thread danielcristian
The following bug has been logged on the website: Bug reference: 8115 Logged by: Daniel Cristian Cruz Email address: danielcrist...@gmail.com PostgreSQL version: 9.2.4 Operating system: CentOS release 5.5, Linux 2.6.18-194.32.1.el5 #1 S Description: I had a server wit

Re: [BUGS] BUG #8114: Peer authentication in cgi-perl

2013-04-25 Thread netterm
I have never used 'ident map" on any system. Yes, I know where the postgresql.conf and pg_hba.conf' files are located on Ubuntu, since I stated I modified them to allow internet connections and to use proper authentication. PostgreSQL has always allowed the apache user (nobody or apache) on some

[BUGS] BUG #8116: create trigger after insert fails if procedure being executed is having error

2013-04-25 Thread nitinmn
The following bug has been logged on the website: Bug reference: 8116 Logged by: CREATE TRIGGER AFTER INSERT FAILS Email address: niti...@gmail.com PostgreSQL version: 9.1.7 Operating system: WINDOWS , UNIX Description: when we create a trigger for a table which basic

[BUGS] BUG #8117: simple but huge query infinite execution time

2013-04-25 Thread haddock
The following bug has been logged on the website: Bug reference: 8117 Logged by: Viacheslav Seledkin Email address: hadd...@mail.ru PostgreSQL version: 9.2.3 Operating system: Linux, Windows Description: you can get query here http://yadi.sk/d/uE-KE0b34LV5A query ha

Re: [BUGS] BUG #8117: simple but huge query infinite execution time

2013-04-25 Thread Tom Lane
hadd...@mail.ru writes: > query has the following scheme > SELECT > regexp_matches('...',' (\d+)\:','g'), > regexp_matches('...','\:([\d\.]+)','g') I'm not sure what you're expecting this to do, but what it will actually do is produce a number of rows equal to the least common multip

Re: [BUGS] BUG #8114: Peer authentication in cgi-perl

2013-04-25 Thread John R Pierce
On 4/25/2013 5:22 AM, netterm wrote: Its only the Ubuntu 12.04 (and perhaps earlier versions) that does not allow the apache user (www-data) and provided data to be different. that error message can only happen with PEER fka IDENT authentication. if peer/ident is in effect, than NO user could