Re: pg_sequence catalog

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_sequence catalog
Date: 2016-10-31 16:25:44
Message-ID: 23d9232e-40be-1b99-809c-9caa4512d12b@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 9/10/16 7:17 AM, Peter Eisentraut wrote:
> Let's start with that. Here is a patch that adds a pg_sequences view in
> the style of pg_tables, pg_indexes, etc. This seems useful independent
> of anything else, but would give us more freedom to change things around
> behind the scenes.

I have registered the pg_sequences view patch separately in the upcoming
commit fest: https://commitfest.postgresql.org/11/865/ (The posted patch
still applies, so no new patch.)

Attached is an updated patch for the pg_sequence catalog. I haven't
received an actual technical review in the last CF, so I'll move it
forward. However, if the pg_sequences view is accepted, the catalog
patch will of course need an update. So if someone is looking here with
limited time, review the view patch first.

As before, this patch requires the "sequences and pg_upgrade" patch in
order for pg_upgrade to work.

I think together these three changes will make sequence metadata
inspection and modification easier and more robust and will facilitate
future changes in this area.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
v2-0001-Add-pg_sequence-system-catalog.patch text/x-patch 42.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message amul sul 2016-10-31 16:26:47 Re: Query regarding selectDumpableExtension()
Previous Message Tom Lane 2016-10-31 16:25:01 Re: Implement targetlist SRFs using ROWS FROM() (was Changed SRF in targetlist handling)