Search Postgresql Archives
Re: Is it safe to rename an index through pg_class update?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Is it safe to rename an index through pg_class update?
From
: Kouber Saparev <kouber@xxxxxxxxx>
Date
: Mon, 23 Mar 2020 18:39:40 +0200
Cc
: Tom Lane <tgl@xxxxxxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
In-reply-to
: <CAN4RuQvm3gsErn-xWsoaO+B1eL_byUW=zdXjWU4SPwOoX0_kHQ@mail.gmail.com>
References
: <CAN4RuQtkwaP90yUvpP8=nJGoYTk_ni50=8e=jHvwHyetz3=MJA@mail.gmail.com> <
21995.1582818756@sss.pgh.pa.us
> <
20200306173805.4yznqcchzojzk7dl@alap3.anarazel.de
> <
CAN4RuQsnrYKWGQyxTsc2YB+88wBhGugMeX3nQgtVH5_hx6LmBg@mail.gmail.com
> <
20200309183440.hptayvs3axqtfc27@alap3.anarazel.de
> <CAN4RuQvm3gsErn-xWsoaO+B1eL_byUW=zdXjWU4SPwOoX0_kHQ@mail.gmail.com>
Just in case somebody else also needs such a functionality in PostgreSQL < 12, I made a function in plpgsql:
https://github.com/kouber/pg_utils/blob/master/rename_index.sql
--
Kouber Saparev
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
References
:
Is it safe to rename an index through pg_class update?
From:
Kouber Saparev
Re: Is it safe to rename an index through pg_class update?
From:
Tom Lane
Re: Is it safe to rename an index through pg_class update?
From:
Andres Freund
Re: Is it safe to rename an index through pg_class update?
From:
Kouber Saparev
Re: Is it safe to rename an index through pg_class update?
From:
Andres Freund
Re: Is it safe to rename an index through pg_class update?
From:
Kouber Saparev
Prev by Date:
Re: PG12 autovac issues
Next by Date:
Re: Runtime partition pruning
Previous by thread:
Re: Is it safe to rename an index through pg_class update?
Next by thread:
Statistics and Index Usage Data
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
