Re: [HACKERS] Re: [BUGS] BUG #8043: 9.2.4 doesn't open WAL files from archive, only looks in pg_xlog

2013-04-09 Thread Christoph Berg
Re: Jeff Janes 2013-04-06 > I don't think the docs are very clear on that. They say "This file will of > course be archived as a part of your backup dump file", but "will be" does > not imply "must be". Elsewhere it emphasizes that the label you gave to > pg_start_backup is written into the fil

[BUGS] BUG #8048: Text Search

2013-04-09 Thread luigisag
The following bug has been logged on the website: Bug reference: 8048 Logged by: Luigi Email address: luigi...@gmail.com PostgreSQL version: 9.2.0 Operating system: Windows 7 Description: I've configured 2 table like this CREATE TABLE "User_Full_Text_Search"

Re: [BUGS] BUG #8048: Text Search

2013-04-09 Thread Kevin Grittner
"luigi...@gmail.com" wrote: > CREATE TABLE "User_Full_Text_Search_2" ( > "Email" varchar(50), > "UserId" varchar(50), > "Full_Text_Search" varchar(4096), > "tsv" varchar(4096) > ) > WITH (OIDS=FALSE) > ; > CREATE INDEX IX_Fu

Re: [BUGS] BUG #8048: Text Search

2013-04-09 Thread Tom Lane
luigi...@gmail.com writes: > CREATE TABLE "User_Full_Text_Search_2" ( > "Email" varchar(50), > "UserId" varchar(50), > "Full_Text_Search" varchar(4096), > "tsv" varchar(4096) > ) > WITH (OIDS=FALSE) > ; You declared tsv as a plain var

[BUGS] BUG #8050: Need quotes around service exe (imagepath registry key)

2013-04-09 Thread mr_gapearce
The following bug has been logged on the website: Bug reference: 8050 Logged by: greg pearce Email address: mr_gapea...@yahoo.com PostgreSQL version: 9.1.2 Operating system: windows 7 x64 Description: The service executable name should be surrounded with double quotes

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

2013-04-09 Thread th
The following bug has been logged on the website: Bug reference: 8049 Logged by: Teun Hoogendoorn Email address: t...@atsc.nl PostgreSQL version: 9.2.4 Operating system: CentOS 6.3 final 64bit Description: Hi, I've got a strange problem with a query that produces mor

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

2013-04-09 Thread Dickson S. Guedes
2013/4/9 : > The following bug has been logged on the website: > > Bug reference: 8049 > Logged by: Teun Hoogendoorn > Email address: t...@atsc.nl > PostgreSQL version: 9.2.4 > Operating system: CentOS 6.3 final 64bit > Description: > > Hi, > > I've got a strange problem with

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

2013-04-09 Thread Dickson S. Guedes
2013/4/9 : > I've got a strange problem with a query that produces more results than > expected. I tested this [1] and saw that 9.1 don't has the behavior then I started bisect from REL9_1_9 to HEAD and found that commit 5b7b5518d0e [2] introduced it. I'm putting a copy to -hacker list in a hope

Re: [BUGS] BUG #8050: Need quotes around service exe (imagepath registry key)

2013-04-09 Thread Amit Kapila
On Tuesday, April 09, 2013 9:33 PM greg pearce wrote: > The following bug has been logged on the website: > > Bug reference: 8050 > Logged by: greg pearce > Email address: mr_gapea...@yahoo.com > PostgreSQL version: 9.1.2 > Operating system: windows 7 x64 > Description: > > T

[BUGS] replication_timeout not effective

2013-04-09 Thread Dang Minh Huong
Hi, I'm wondering if this is a bug of PostgreSQL. PostgreSQL's show that replication_timeout parameter can "Terminate replication connections that are inactive longer than the specified number of milliseconds". But in my environment the sender process is hang up (in several tens of minunites)

Re: [BUGS] replication_timeout not effective

2013-04-09 Thread Amit Kapila
On Wednesday, April 10, 2013 9:35 AM Dang Minh Huong wrote: > Hi, > I'm wondering if this is a bug of PostgreSQL. > PostgreSQL's show that replication_timeout parameter can "Terminate > replication connections that are inactive longer than the specified number of > milliseconds". But in my env

[BUGS] BUG #8056: postgres forgets hstore over time

2013-04-09 Thread knowzerox
The following bug has been logged on the website: Bug reference: 8056 Logged by: Eugene Email address: knowze...@yahoo.com PostgreSQL version: 9.2.1 Operating system: centos 6 64bit Description: I have hstore installed on my server and it works fine. But sometimes pos