Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> I don't think so. There's no ALTER RULE command; should we add one
> (matching ALTER TRIGGER) or make this part of ALTER TABLE? I don't
> think constraints can be renamed either, which should probably be
> addressed along with rules.
Note that renaming an index-based constraint should also rename the
index. I believe the other direction works already.
regards, tom lane