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
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.
"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
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
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
"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
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'),
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
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');
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
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
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
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
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
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
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
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
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
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
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:
>
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
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
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
23 matches
Mail list logo
