Re: operator dependency of commutator and negator - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: operator dependency of commutator and negator
Date
Msg-id 1285769761-sup-8397@alvh.no-ip.org
Whole thread Raw
In response to operator dependency of commutator and negator  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Responses Re: operator dependency of commutator and negator  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Excerpts from Itagaki Takahiro's message of mié sep 29 03:56:33 -0400 2010:
> 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?

Maybe we need a pg_depend entry from each pg_operator entry to the other
one.  The problem is that this creates a cycle in the depends graph; not
sure how well these are handled in the code, if at all.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Itagaki Takahiro
Date:
Subject: Re: I: About "Our CLUSTER implementation is pessimal" patch
Next
From: "Colin 't Hart"
Date:
Subject: Re: documentation udpates to pgupgrade.html