Re: Sequence Access Method WIP

On 29/03/16 18:50, Fabrízio de Royes Mello wrote:
>
>
> On Tue, Mar 29, 2016 at 12:25 PM, David Steele <david@pgmasters.net
> <mailto:david@pgmasters.net>> wrote:
>  >
>  > Hi Petr,
>  >
>  > On 3/28/16 3:11 PM, Fabrízio de Royes Mello wrote:
>  >
>  >> fabrizio@bagual:~/pgsql
>  >> $ bin/pg_dump > /tmp/fabrizio.sql
>  >> pg_dump: [archiver (db)] query failed: ERROR:  column "sequence_name"
>  >> does not exist
>  >> LINE 1: SELECT sequence_name, start_value, increment_by, CASE WHEN i...
>  >>                 ^
>  >> pg_dump: [archiver (db)] query was: SELECT sequence_name, start_value,
>  >> increment_by, CASE WHEN increment_by > 0 AND max_value =
>  >> 9223372036854775807 THEN NULL      WHEN increment_by < 0 AND max_value =
>  >> -1 THEN NULL      ELSE max_value END AS max_value, CASE WHEN
>  >> increment_by > 0 AND min_value = 1 THEN NULL      WHEN increment_by < 0
>  >> AND min_value = -9223372036854775807 THEN NULL      ELSE min_value END
>  >> AS min_value, cache_value, is_cycled FROM x
>  >
>  >
>  > It looks like a new patch is needed.  I've marked this "waiting on
> author".
>  >
>

Yeah there were some incompatible commits since my last rebase, fixed,
along with the pg_dump bugs..

>
> But there are other issue in the gapless-seq extension when I ran "make
> check":
>
>   43   CREATE EXTENSION gapless_seq;
>   44   CREATE SEQUENCE test_gapless USING gapless;
>   45   SELECT nextval('test_gapless'::regclass);
>   46 ! ERROR:  could not access status of transaction 1275068416
>   47 ! DETAIL:  Could not open file "pg_subtrans/4C00": No such file or
> directory.
>   48   BEGIN;
>   49     SELECT nextval('test_gapless'::regclass);
>   50 ! ERROR:  could not access status of transaction 1275068416
>   51 ! DETAIL:  Could not open file "pg_subtrans/4C00": No such file or
> directory.
>   52     SELECT nextval('test_gapless'::regclass);
>   53 ! ERROR:  current transaction is aborted, commands ignored until
> end of transaction block
>   54     SELECT nextval('test_gapless'::regclass);
>   55 ! ERROR:  current transaction is aborted, commands ignored until
> end of transaction block
>   56   ROLLBACK;
>   57   SELECT nextval('test_gapless'::regclass);
>   58 ! ERROR:  could not access status of transaction 1275068416
>   59 ! DETAIL:  Could not open file "pg_subtrans/4C00": No such file or
> directory.
>
>
> And I see the same running manually:
>
> fabrizio=# create extension gapless_seq;
> CREATE EXTENSION
> fabrizio=# create sequence x using gapless;
> CREATE SEQUENCE
> fabrizio=# select nextval('x');
> ERROR:  could not access status of transaction 1258291200
> DETAIL:  Could not open file "pg_subtrans/4B00": No such file or directory.
>
> Regards,
>

Hmm I am unable to reproduce this. What OS? Any special configure flags
you use?


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