Home > mailing lists

Alter Table from Trigger - Mailing list pgsql-novice

From	Tamara Tardif
Subject	Alter Table from Trigger
Date	March 19, 2020 19:32:02
Msg-id	CAGpg+FFC_Ysrx3LtEpUK69-ne-2EJbmMvhS1pCehP4s1CZP=4Q@mail.gmail.com Whole thread Raw
Responses	Re: Alter Table from Trigger ("David G. Johnston" <david.g.johnston@gmail.com>)
List	pgsql-novice

Hello,

Is altering a table from its own trigger possible? If not, how come?

For context, I am trying to attach a partition to a table using a trigger on that same table. Here is the error:

ERROR: cannot ALTER TABLE "tablename" because it is being used by active queries in this session

Any help would be greatly appreciated.

Thanks,

Tamara

From: Aman Dhaka
Date: 18 March 2020, 03:59:30
Subject: not able to connect.

From: "David G. Johnston"
Date: 19 March 2020, 20:06:23
Subject: Re: Alter Table from Trigger