pg.ddx.io  pgsql-patches@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Ryan Bradetich <rbradetich@gmail.com>
To: Jaime Casanova <jcasanov@systemguards.com.ec>
Cc: pgsql-patches <pgsql-patches@postgresql.org>
Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2]
Date: Mon, 8 Sep 2008 23:25:31 -0700
Message-ID: <e739902b0809082325s69c21814mbc0dc8dfd6ebfec6@mail.gmail.com> (raw)
In-Reply-To: <3073cc9b0809082254g789a7f14x45e9d416925b1057@mail.gmail.com>
References: <e739902b0808311335l1ad5d425r2704429c386f2f88@mail.gmail.com>
	<3073cc9b0809061341q5c747488i85491e4c8e2420ba@mail.gmail.com>
	<3073cc9b0809062330o62fd74dax74b1730cedc0fbb9@mail.gmail.com>
	<e739902b0809082008p6c694a20ufd526d1ce5d46750@mail.gmail.com>
	<3073cc9b0809082254g789a7f14x45e9d416925b1057@mail.gmail.com>

Hello Jaime,

Thank you for the test cases!

> mmm... i rebuild my test env and it works for me this time... until i
> execute an analyze. I guess autovacuum executed an auto analyze last
> time...

I am able to duplicate the error you saw in the uint_test2.sql.

I am assuming you are seeing this error in the uint_test1.sql:
    ERROR:  could not find hash function for hash operator 16524

I can bypass the error in uint_test1.sql by disabling the hash joins.
I am going to dig in and figure out why the hashjoin operation is broken.

Just wanted to give you an update that I was able to reproduce the
error with your test cases and I am working on a solution now.

Thanks!

- Ryan

view thread (26+ messages)  latest in thread

Message-ID: <e739902b0809082325s69c21814mbc0dc8dfd6ebfec6@mail.gmail.com>
Permalink:  ../e739902b0809082325s69c21814mbc0dc8dfd6ebfec6@mail.gmail.com/
Also on:    postgresql.org/message-id/e739902b0809082325s69c21814mbc0dc8dfd6ebfec6@mail.gmail.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-patches@postgresql.org
  Cc: rbradetich@gmail.com, jcasanov@systemguards.com.ec
  Subject: Re: [PgFoundry] Unsigned Data Types [1 of 2]
  In-Reply-To: <e739902b0809082325s69c21814mbc0dc8dfd6ebfec6@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox