[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: trigger creation failed
From:       kaido vaikla <kaido.vaikla () gmail ! com>
Date:       2023-05-22 11:15:15
Message-ID: CA+427g9tD=RAwpLD=e0of5JR-wqzHRMFyRqXqE-a7SErvOp2cQ () mail ! gmail ! com
[Download RAW message or body]

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

in proper database
br
Kaido

On Mon, 22 May 2023 at 12:51, Nikhil Ingale <niks.bgm@gmail.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
>

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_default" style="font-family:monospace,monospace">For \
triggers<br>postgres=# \dft+ *.*<br>For tables<br>postgres=# \dt+ *.*<br><br>in \
proper database<br>br<br>Kaido</div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Mon, 22 May 2023 at 12:51, Nikhil Ingale &lt;<a \
href="mailto:niks.bgm@gmail.com">niks.bgm@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hi \
All,<br></div><div>Need help on following error.</div><div><br></div><div><span \
dir="ltr">ERROR:   replicated relation map_profile cannot have triggers that are \
owned by roles other than the relation owner</span><br></div><div><span \
dir="ltr"><br></span></div><div><span dir="ltr">How do I check the owner of table and \
trigger?</span></div><div><span dir="ltr"><br></span></div><div><span \
dir="ltr">Regards,</span></div><div><span dir="ltr">Nik</span></div></div> \
</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]