Re: record identical operator - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: record identical operator
Date
Msg-id m2ob7p68qj.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: record identical operator  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: record identical operator
Re: record identical operator
List pgsql-hackers
Kevin Grittner <kgrittn@ymail.com> writes:
> You are arguing that we should provide lesser support for numeric
> columns (and who knows how many other types) in materialized views
> than we do in streaming replication, pg_dump,
> suppress_redundant_updates_trigger(), and other places?  Why?

Because you're saying that you need SQL semantics, and probably because
I'm not understanding well enough the problem you're trying to solve.

> We have, as a community, gone to a fair amount of trouble  to make
> the concept of equality pluggable and allow multiple types of
> equality per type.  To me it seems the perfect tool to solve this
> problem.  Why the fuss?

Because I don't understand why you need another equality than the
default btree one, certainly. The other opclass, to my knowledge, are
only used in relation with index searches, that is when comparing heap
or input values with indexed values, right?

> No, matviews cannot be fixed without the new operators.  Here are
> the stats on the patch:

Ok, then someone (preferably a commiter) need to understand the problem
at hand in a better way than I do now, I guess. If possible I will read
through your patch, I'm curious now.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support



pgsql-hackers by date:

Previous
From: "MauMau"
Date:
Subject: Re: UTF8 national character data type support WIP patch and list of open issues.
Next
From: Vik Fearing
Date:
Subject: Re: record identical operator