Re: recording of INDEX creation in tables

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Matthias Apitz <guru(at)unixarea(dot)de>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: recording of INDEX creation in tables
Date: 2022-01-22 06:38:44
Message-ID: CAKFQuwbMTHBXFYyoB-bAvsKMUh+6MsQWwgFof+joC4h2SEcWzA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 21, 2022 at 5:39 AM Matthias Apitz <guru(at)unixarea(dot)de> wrote:

>
> Hello,
>
> Does the PostgreSQL (11.4 or 13.1) record somewhere in system tables
> the creation of INDEXes (or other objects)?
>
>
13.1? Really?

Features are not point-release dependent so v11 or v13 suffices when trying
to figure out whether some feature exists.

PostgreSQL does not provide auditing-type information in its system tables,
they simply represent the current state. Some features can be used to
manually (possibly through community-provided extensions) record such data
to non-system tables (which is usually fine with the proper permission
setup) or the server log.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2022-01-22 10:21:03 Re: recording of INDEX creation in tables
Previous Message Michael Paquier 2022-01-22 06:11:34 Re: How are md5.h: pg_md5_hash() function and below functions working?