Re: Sequence Access Method WIP

Petr Jelinek <petr@2ndquadrant.com>

From: Petr Jelinek <petr@2ndquadrant.com>
To: Heikki Linnakangas <hlinnakangas@vmware.com>, Simon Riggs <simon@2ndQuadrant.com>
Cc: Andres Freund <andres@2ndquadrant.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Alvaro Herrera <alvherre@2ndquadrant.com>
Date: 2015-02-15T18:40:24Z
Lists: pgsql-hackers

Attachments

Hi,

sending new version that is updated along the lines of what we discussed 
at FOSDEM, which means:

- back to single bytea amdata column (no custom columns)

- the dump/restore interfaces were changed to produce/accept array of 
key/value pairs

- psql shows the output of dump interface in verbose mode (this makes it 
easier to inspect the state)

- last_value and is_called are always present columns even if the 
sequence am does not care for them (this helps with backwards 
compatibility with various admin tools)

- pg_dump uses new interface for dumping only for non-local sequences so 
that dumps of schemas which are not using custom seqams are restorable 
to older postgres

- the default_sequenceam was changed to serial_sequenceam and only 
applies to serial/bigserial columns - I would personally prefer to have 
the old default but default for serial is better than nothing

- added description of pg_seqam catalog to docs

- gapless_seq still uses table internally to support snapshots for pg_dump

- pg_dump support for dumping the sequence ams


It would be nice to also have something along the lines of chapter 55.2. 
(Index Access Method Functions), I plan to send that as additional patch 
in few days.

-- 
  Petr Jelinek                  http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services

Commits

  1. Add missing gss option to msvc config template