Re: WIP: Enhanced ALTER OPERATOR
От
Jeff Janes
Тема
Re: WIP: Enhanced ALTER OPERATOR
Дата
Msg-id
CAMkU=1zOJT9N8eaQMKjS6z=295DZst4fAhEhvf9fYUXt-gkEVg@mail.gmail.com
Ответ на
Re: WIP: Enhanced ALTER OPERATOR (Heikki Linnakangas)
Список
Дерево обсуждения
WIP: Enhanced ALTER OPERATOR Uriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: Enhanced ALTER OPERATOR Uriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Uriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Alvaro Herrera <alvherre@2ndquadrant.com>
Re: WIP: Enhanced ALTER OPERATOR Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: Enhanced ALTER OPERATOR Andres Freund <andres@anarazel.de>
Re: WIP: Enhanced ALTER OPERATOR Uriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Robert Haas <robertmhaas@gmail.com>
Re: WIP: Enhanced ALTER OPERATOR Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: Enhanced ALTER OPERATOR Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Robert Haas <robertmhaas@gmail.com>
Re: WIP: Enhanced ALTER OPERATOR Uriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Uriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Robert Haas <robertmhaas@gmail.com>
Re: WIP: Enhanced ALTER OPERATOR Uriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Uriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Heikki Linnakangas <hlinnaka@iki.fi>
Re: WIP: Enhanced ALTER OPERATOR Uriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: WIP: Enhanced ALTER OPERATOR Jeff Janes <jeff.janes@gmail.com>
Re: WIP: Enhanced ALTER OPERATOR Heikki Linnakangas <hlinnaka@iki.fi>
Re: WIP: Enhanced ALTER OPERATOR Heikki Linnakangas <hlinnaka@iki.fi>
Re: WIP: Enhanced ALTER OPERATOR Uriy Zhuravlev <u.zhuravlev@postgrespro.ru>
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 по дате отправления