operator dependency of commutator and negator

Поиск
Список
Период
Сортировка
Искать
От
Itagaki Takahiro
Тема
operator dependency of commutator and negator
Дата
Msg-id
AANLkTi=m9oGUEsz_zZZ8qUTpoRj6+zMqfBkVymrZn9H5@mail.gmail.com
Список
Дерево обсуждения
operator dependency of commutator and negator Itagaki Takahiro <itagaki.takahiro@gmail.com>
Re: operator dependency of commutator and negator Alvaro Herrera <alvherre@commandprompt.com>
Re: operator dependency of commutator and negator Tom Lane <tgl@sss.pgh.pa.us>
Re: operator dependency of commutator and negator Itagaki Takahiro <itagaki.takahiro@gmail.com>
Re: operator dependency of commutator and negator Tom Lane <tgl@sss.pgh.pa.us>
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

В списке pgsql-hackers по дате отправления
От: Leonardo Francalanci
Дата:
От: Shigeru HANADA
Дата:
Сообщение: Re: patch: SQL/MED(FDW) DDL
FAQ