Re: OWNER TO on all objects - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: OWNER TO on all objects
Date
Msg-id 200406151904.01803.peter_e@gmx.net
Whole thread Raw
In response to Re: OWNER TO on all objects  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: OWNER TO on all objects  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Christopher Kings-Lynne wrote:
> >> * Is there any reason there is no RENAME TO command for operators?
> >
> > That might change the precedence of the operator
>
> ... true ...
>
> > and get you in a big mess with stored expressions everywhere.
>
> Not with respect to compiled expressions.  It could conceivably break
> stored function source texts and application-generated queries, but
> those are broken a fortiori by the new operator name.
>
> So I don't think this objection has a lot of weight.

IIRC, it was the objection that you put forth when I last attempted to 
do it...  The question is perhaps not so much whether we can get away 
with it, it's whether the behavior is reasonable and consistent for 
users that don't know implementation details.



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: OWNER TO on all objects
Next
From: "Marc G. Fournier"
Date:
Subject: Re: 7.4.3 running a bit late ...