Postgres Pro
Downloads
Home   >   mailing lists

Re: recording of INDEX creation in tables - Mailing list pgsql-general

From David G. Johnston
Subject Re: recording of INDEX creation in tables
Date
Msg-id CAKFQuwbMTHBXFYyoB-bAvsKMUh+6MsQWwgFof+joC4h2SEcWzA@mail.gmail.com
Whole thread Raw
In response to recording of INDEX creation in tables  (Matthias Apitz <guru@unixarea.de>)
Responses Re: recording of INDEX creation in tables
List pgsql-general
Tree view
On Fri, Jan 21, 2022 at 5:39 AM Matthias Apitz <guru@unixarea.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.

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: How are md5.h: pg_md5_hash() function and below functions working?
Next
From: Matthias Apitz
Date:
Subject: Re: recording of INDEX creation in tables