Search Postgresql Archives

Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Aug 2, 2021 at 12:20 PM Dhanush D <dhanushdk94@xxxxxxxxx> wrote:
It doesn't show up twice based on these checks (Is there any other way I can check if the seq is showing up twice?).


 SELECT * FROM pg_class WHERE relkind = 'S' AND relname ~ 'permission';

I made the "relname" a bit broad, you should see the exact name (add an order by...).  relkind=S are sequences.

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux