Re: [BUGS] [GENERAL] Hello, i want to subscribe...

2009-04-03 Thread itishree sukla
On Fri, Apr 3, 2009 at 2:35 AM, Ricardo Fuentes wrote: > Hello, i want to subscribe to this lists > Hi Ricardo, Here is the link to subscribe. http://www.postgresql.org/community/lists/ Regards, Itishree

Re: [BUGS] BUG #4744: Windows 2008: FATAL: could not reattach to shared memory: 487

2009-04-03 Thread Ghislain ROUVIGNAC
Hello, I made some further investigations. It seems that my problem was related with my new server hostname. He was named ctrl_cochise which does not conform to standards. After renaming to ctrlcochise I have not been able to reproduce my problems. Something strange is that I was not able

[BUGS] bug report

2009-04-03 Thread n.franken3
Sir, I have changed Antivirus environment from AVG to Avast . After I have tried to restart my PostgreSQL Server I got 10061 error TCP/IP. Starting the server triggers err 5 ''Access denied'' After this missfaillure I have uninstalled PostgreSQL 8.3. and then I have tried to riinstall Postg

Re: [BUGS] BUG #4694: uppercase path cause postgres can't start

2009-04-03 Thread Magnus Hagander
trainee wrote: > The following bug has been logged online: > > Bug reference: 4694 > Logged by: trainee > Email address: traine...@163.com > PostgreSQL version: 8.3.6 > Operating system: windows xp > Description:uppercase path cause postgres can't start > Details: >

Re: [BUGS] MD5 checksum or RPM for PostgreSQL 8.7.3

2009-04-03 Thread Dafina.Abernathy
To Whom It My Concern, I am a member of a small group using PostgreSQL has a data backend and I writing to request and MD5 checksum for PostgreSQL 8.7.3. If an MD5 is not available, I would appreciate the location of an RPM for 8.7.3, if there is one available. Thank you very much for your as

Re: [BUGS] MD5 checksum or RPM for PostgreSQL 8.7.3

2009-04-03 Thread John R Pierce
Dafina.Abernathy wrote: To Whom It My Concern, I am a member of a small group using PostgreSQL has a data backend and I writing to request and MD5 checksum for PostgreSQL 8.7.3. If an MD5 is not available, I would appreciate the location of an RPM for 8.7.3, if there is one available. Thank

Re: [BUGS] MD5 checksum or RPM for PostgreSQL 8.7.3

2009-04-03 Thread Dafina.Abernathy
Hello Mr. Pierce, You are correct it is for version 8.3.7. for Redhat. My apologies for the mix-up. A member of the group has checked http://yums.postgresql.org and was unable to locate an RPM for Redhat. If there is one available, I would be most appreciative if you provided the link. Thank

Re: [BUGS] MD5 checksum or RPM for PostgreSQL 8.7.3

2009-04-03 Thread Dave Page
On Fri, Apr 3, 2009 at 5:12 PM, Dafina.Abernathy wrote: > Hello Mr. Pierce, > > You are correct it is for version 8.3.7. for Redhat. My apologies for the > mix-up. > A member of the group has checked http://yums.postgresql.org  and was unable > to locate an RPM for Redhat. > If there is one availa

Re: [BUGS] MD5 checksum or RPM for PostgreSQL 8.7.3

2009-04-03 Thread John R Pierce
John R Pierce wrote: Dafina.Abernathy wrote: I am a member of a small group using PostgreSQL has a data backend and I writing to request and MD5 checksum for PostgreSQL 8.7.3. If an MD5 is not available, I would appreciate the location of an RPM for 8.7.3, if there is one available. Thank you

Re: [BUGS] MD5 checksum or RPM for PostgreSQL 8.7.3

2009-04-03 Thread John R Pierce
Dafina.Abernathy wrote: Hello Mr. Pierce, You are correct it is for version 8.3.7. for Redhat. My apologies for the mix-up. A member of the group has checked http://yums.postgresql.org and was unable to locate an RPM for Redhat. "Redhat" describes a dozen versions of Linux and a half dozen

Re: [BUGS] MD5 checksum or RPM for PostgreSQL 8.7.3

2009-04-03 Thread Josh Berkus
Dafina, I am a member of a small group using PostgreSQL has a data backend and I writing to request and MD5 checksum for PostgreSQL 8.7.3. If an MD5 is not available, I would appreciate the location of an RPM for 8.7.3, if there is one available. Thank you very much for your assistance in this m

Re: [BUGS] MD5 checksum or RPM for PostgreSQL 8.7.3

2009-04-03 Thread P. Scott Hill
Sorry for the confusion and ambiguity of the request. The files we are requesting the MD5 checksum for are located here: http://www.postgresql.org/ftp/binary/v8.3.7/linux/rpms/redhat/rhel-4-i386/ Thanks! P. Scott Hill Software Engineer, Web Development Group National Coastal Data Development

[BUGS] BUG #4748: hash join and sort-merge join make different results

2009-04-03 Thread Roman Kononov
The following bug has been logged online: Bug reference: 4748 Logged by: Roman Kononov Email address: kono...@ftml.net PostgreSQL version: 8.3.7 Operating system: GNU/Linux x86_64 Description:hash join and sort-merge join make different results Details: test-std=# c

Re: [BUGS] BUG #4748: hash join and sort-merge join make different results

2009-04-03 Thread Alvaro Herrera
Roman Kononov wrote: > Description:hash join and sort-merge join make different results > Details: > > test-std=# create table t(s int,i interval); > CREATE TABLE > test-std=# insert into t values (0,'30 days'), (1,'1 month'); > INSERT 0 2 > test-std=# select * from t as a, t as b where

Re: [BUGS] BUG #4748: hash join and sort-merge join make different results

2009-04-03 Thread Jaime Casanova
On Fri, Apr 3, 2009 at 2:10 PM, Alvaro Herrera wrote: > Roman Kononov wrote: > >> Description:        hash join and sort-merge join make different results >> Details: >> >> test-std=# create table t(s int,i interval); >> CREATE TABLE >> test-std=# insert into t values (0,'30 days'), (1,'1 month');

Re: [BUGS] BUG #4748: hash join and sort-merge join make different results

2009-04-03 Thread Tom Lane
Alvaro Herrera writes: > Roman Kononov wrote: >> Description:hash join and sort-merge join make different results >> Details: >> >> test-std=# create table t(s int,i interval); >> CREATE TABLE >> test-std=# insert into t values (0,'30 days'), (1,'1 month'); >> INSERT 0 2 >> test-std=# se

Re: [BUGS] BUG #4748: hash join and sort-merge join make different results

2009-04-03 Thread Dickson S. Guedes
Em Sex, 2009-04-03 às 15:10 -0400, Alvaro Herrera escreveu: > Roman Kononov wrote: > > > Description:hash join and sort-merge join make different results > > Details: > > > > test-std=# create table t(s int,i interval); > > CREATE TABLE > > test-std=# insert into t values (0,'30 days'),

Re: [BUGS] BUG #4748: hash join and sort-merge join make different results

2009-04-03 Thread Tom Lane
"Dickson S. Guedes" writes: > I could reproduce this once in a database that already have a table > named "t", then after i did dropped it i couldn't anymore. As noted, you might have to force use of a hash join (my machine preferred a mergejoin before the ANALYZE and a nestloop after). It's defi

Re: [BUGS] BUG #4748: hash join and sort-merge join make different results

2009-04-03 Thread Roman Kononov
On 2009-04-03 14:57 Tom Lane said the following: I think we could fix this by having interval_hash() duplicate the total-span calculation done by interval_cmp_internal, and then return the hash of the resulting TimeOffset. This is going to break existing hash indexes on intervals, but there seem

Re: [BUGS] BUG #4748: hash join and sort-merge join make different results

2009-04-03 Thread Tom Lane
Roman Kononov writes: > On 2009-04-03 14:57 Tom Lane said the following: >> I think we could fix this by having interval_hash() duplicate the >> total-span calculation done by interval_cmp_internal, and then return >> the hash of the resulting TimeOffset. This is going to break existing >> hash i

Re: [BUGS] BUG #4748: hash join and sort-merge join make different results

2009-04-03 Thread Tom Lane
"Roman Kononov" writes: > Description:hash join and sort-merge join make different results I've applied a patch for this: http://archives.postgresql.org/pgsql-committers/2009-04/msg00048.php Thanks for the report! regards, tom lane -- Sent via pgsql-bugs mailin

Re: [BUGS] BUG #4748: hash join and sort-merge join make different results

2009-04-03 Thread Roman Kononov
On 2009-04-03 23:32 Tom Lane said the following: Roman Kononov writes: On 2009-04-03 14:57 Tom Lane said the following: I think we could fix this by having interval_hash() duplicate the total-span calculation done by interval_cmp_internal, and then return the hash of the resulting TimeOffset.

Re: [BUGS] BUG #4748: hash join and sort-merge join make different results

2009-04-03 Thread Tom Lane
Roman Kononov writes: > On 2009-04-03 23:32 Tom Lane said the following: >> Uh, what's your point? We have to match interval_eq, not >> justify_interval. > For any two intervals a and b, saying that interval_cmp_interval(a,b)==0 > is exactly the same as saying that (aj.month==bj.month && aj.day