Re: trigger creation failed

From: kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com>
To: Nikhil Ingale <niks(dot)bgm(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: trigger creation failed
Date: 2023-05-22 11:15:15
Message-ID: CA+427g9tD=RAwpLD=e0of5JR-wqzHRMFyRqXqE-a7SErvOp2cQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

For triggers
postgres=# \dft+ *.*
For tables
postgres=# \dt+ *.*

in proper database
br
Kaido

On Mon, 22 May 2023 at 12:51, Nikhil Ingale <niks(dot)bgm(at)gmail(dot)com> wrote:

> Hi All,
> Need help on following error.
>
> ERROR: replicated relation map_profile cannot have triggers that are
> owned by roles other than the relation owner
>
> How do I check the owner of table and trigger?
>
> Regards,
> Nik
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Wilson Coelho 2023-05-22 12:49:11 Re: RDS No free space
Previous Message Nikhil Ingale 2023-05-22 09:50:44 trigger creation failed