On Wed, Sep 25, 2019 at 5:08 AM Raghavendra Rao J S V < raghavendra...@gmail.com> wrote:
> *Reason:* > > *SQL Error [0A000]: ERROR: cannot alter type of a column used in a trigger > definition Detail: trigger extensiontrigger on table tele depends on > column "phonenumber"* > > Do I need to drop the trigger and alter the table column to modify the > datatype of the columns. Am I correct? > Seems like a reasonable course of action, and simple enough to just experiment with on a test relation. > or is there any other way to resolve it. > Doubtful David J.
