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
Дата: