Receivgin error while altering the table column datatype

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Receivgin error while altering the table column datatype
Date: 2019-09-25 09:41:06
Message-ID: CAEHH7R6ZVn0G33E8wFtJp_cHk=WffM0kA+idjr3OJ-QzR3GAPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I am receiving below error while altering the table column datatype.

*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? or is there any other way to resolve
it.

--
Regards,
Raghavendra Rao J S V

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Миша Тюрин 2019-09-25 10:18:00 pgq is one of the most underrated pg related stuff
Previous Message Krishnakant Mane 2019-09-25 07:15:20 managing primary key conflicts while restoring data to table with existing data