Re: WIP: Enhanced ALTER OPERATOR - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: WIP: Enhanced ALTER OPERATOR
Date
Msg-id CAMkU=1zOJT9N8eaQMKjS6z=295DZst4fAhEhvf9fYUXt-gkEVg@mail.gmail.com
Whole thread Raw
In response to Re: WIP: Enhanced ALTER OPERATOR  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: WIP: Enhanced ALTER OPERATOR  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-hackers
On Tue, Jul 14, 2015 at 8:22 AM, Heikki Linnakangas <hlinnaka@iki.fi> wrote:
On 07/13/2015 03:43 PM, Uriy Zhuravlev wrote:
  Hello hackers.

Attached is a new version of patch:
* port syntax from NULL to truth NONE
* fix documentation (thanks Heikki)
* rebase to master

Thanks, committed after some editing. I put all the logic into AlterOperator function, in operatorcmds.c, rather than pg_operator.c. I think that's how we've lately organized commands. I also simplified the code quite a bit - I think you had copy-pasted from one of the generic ALTER variants, like AlterOwnerStmt, which was overly generic for ALTER OPERATOR. No need to look up the owner/name attributes dynamically, etc.

There was one genuine bug that I fixed: the ALTER OPERATOR command didn't check all the same conditions that CREATE OPERATOR did, namely that only binary operators can have join selectivity, and that only boolean operators can have restriction/join selectivity.


I'm getting some compiler warnings now:

operatorcmds.c: In function 'AlterOperator':
operatorcmds.c:504: warning: 'address.objectSubId' may be used uninitialized in this function
operatorcmds.c:365: note: 'address.objectSubId' was declared here
operatorcmds.c:504: warning: 'address.objectId' may be used uninitialized in this function
operatorcmds.c:365: note: 'address.objectId' was declared here
operatorcmds.c:504: warning: 'address.classId' may be used uninitialized in this function
operatorcmds.c:365: note: 'address.classId' was declared here

gcc version 4.4.7 20120313 (Red Hat 4.4.7-11) (GCC)


Thanks,

Jeff

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Minor issue with BRIN regression tests
Next
From: Thom Brown
Date:
Subject: Re: Support retrieving value from any sequence