Skip site navigation (1) Skip section navigation (2)

operator dependency of commutator and negator

From: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: operator dependency of commutator and negator
Date: 2010-09-29 07:56:33
Message-ID: AANLkTi=m9oGUEsz_zZZ8qUTpoRj6+zMqfBkVymrZn9H5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
When we drop an operator used by other operators as COMMUTATOR or NEGATOR,
pg_dump generates an invalid SQL command for the operators depending on
the dropped one. Is it an unavoidable restriction?

  CREATE OPERATOR <<< (
    PROCEDURE = text_lt, LEFTARG = text, RIGHTARG = text, COMMUTATOR = >>>
  );
  CREATE OPERATOR >>> (
    PROCEDURE = text_gt, LEFTARG = text, RIGHTARG = text, COMMUTATOR = <<<
  );
  DROP OPERATOR >>> (text, text);

$ pg_dump
--
-- Name: <<<; Type: OPERATOR; Schema: public; Owner: postgres
--
CREATE OPERATOR <<< (
    PROCEDURE = text_lt,
    LEFTARG = text,
    RIGHTARG = text,
    COMMUTATOR = 16395      <== HERE
);


-- 
Itagaki Takahiro

Responses

pgsql-hackers by date

Next:From: Shigeru HANADADate: 2010-09-29 07:56:48
Subject: Re: patch: SQL/MED(FDW) DDL
Previous:From: Leonardo FrancalanciDate: 2010-09-29 07:17:07
Subject: Re: I: About "Our CLUSTER implementation is pessimal" patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group