[BUGS] BUG #5328: GIN index with fastupdates=on provide wrong result on bitmap scan

2010-02-16 Thread Maxim Boguk
The following bug has been logged online: Bug reference: 5328 Logged by: Maxim Boguk Email address: maxim.bo...@gmail.com PostgreSQL version: 8.4.1 Operating system: linux kernel v 2.6.18 Description:GIN index with fastupdates=on provide wrong result on bitmap scan De

Re: [BUGS] BUG #5328: GIN index with fastupdates=on provide wrong result on bitmap scan

2010-02-16 Thread Tom Lane
"Maxim Boguk" writes: > Bug reference: 5328 > Logged by: Maxim Boguk > Email address: maxim.bo...@gmail.com > PostgreSQL version: 8.4.1 > Operating system: linux kernel v 2.6.18 > Description:GIN index with fastupdates=on provide wrong result on > bitmap scan The 8.4.

Re: [BUGS] BUG #5327: postgresql gives checksum error when upgrading 8.2.6 binaries to 8.2.14 in windows.

2010-02-16 Thread Bruce Momjian
The short answer is that you should not be changing any build configurations if changing from one minor release to another. Are you sure you are using the same build setup? --- janandith wrote: > > The following bug has be

[BUGS] BUG #5329: postmaster fails to start because of an erroneous pg_hba.conf, but doesn't output any error

2010-02-16 Thread Olivier Jeannet
The following bug has been logged online: Bug reference: 5329 Logged by: Olivier Jeannet Email address: olivier.jean...@gmail.com PostgreSQL version: 8.4.2 Operating system: Fedora 12 on x86_64 Description:postmaster fails to start because of an erroneous pg_hba.conf,

[BUGS] Postgresql Relations disappear

2010-02-16 Thread sergio dominguez
Hello, good morning! I started to work with postgresql but i find that all the relations I create disappear when I quit (\q) from the interactive terminal or after load a sql file. I tried to find something about this bug but I haven't found anything about that, I would really appreciate if you co

Re: [BUGS] Postgresql Relations disappear

2010-02-16 Thread Euler Taveira de Oliveira
sergio dominguez escreveu: > I started to work with postgresql but i find that all the relations I > create disappear when I quit (\q) > This is not a bug. I bet your tables are loaded into a schema that is not in the search_path. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Se

Re: [BUGS] BUG #5329: postmaster fails to start because of an erroneous pg_hba.conf, but doesn't output any error

2010-02-16 Thread Tom Lane
"Olivier Jeannet" writes: > After having modified "pg_hba.conf" in bad way, with the following line (the > IP address is not used and not wanted) : > local all all 127.0.0.1md5 > postmaster was unable to start as usual. > I had a hard time finding the problem, as nothing is ouput

Re: [BUGS] Postgresql Relations disappear

2010-02-16 Thread Tom Lane
sergio dominguez writes: > I started to work with postgresql but i find that all the relations I create > disappear when I quit (\q) from the interactive terminal or after load a sql > file. It's difficult to say for sure when you haven't showed us exactly what you did, but one possibility is tha

Re: [BUGS] BUG #5329: postmaster fails to start because of an erroneous pg_hba.conf, but doesn't output any error

2010-02-16 Thread Euler Taveira de Oliveira
Olivier Jeannet escreveu: > I had a hard time finding the problem, as nothing is ouput on the command > line or in the logs. > Ugh? I got this in 8.4 or earlier version. Are you checking the right log file? LOG: invalid authentication method "127.0.0.1/32" CONTEXT: line 74 of configuration file

Re: [BUGS] BUG #5326: The 2nd update of a table which has foreign keys is blocked.

2010-02-16 Thread Tom Lane
Takahiro Itagaki writes: > But to be exact, the comment says we *can* still skip the checks > if we don't have any deferred FKs, right? If so, can we add > a "has_deferred_FKs()" check to the condition? > if ((!has_deferred_FKs(rel) || > !TransactionIdIsCurrentTransactionId(...)) && > R