Re: Sequence Access Method WIP

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: Sequence Access Method WIP
Дата
Msg-id CAFcNs+q9VKkiHDXSqM+LWrVnbBc3-tEV=V5q9hFJvMCfYL3mVA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Sequence Access Method WIP  (David Steele <david@pgmasters.net>)
Ответы Re: Sequence Access Method WIP
Список pgsql-hackers
Дерево обсуждения


On Tue, Mar 29, 2016 at 12:25 PM, David Steele <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".
>

The attached patches fix the issues previous pointed by me.

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,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello
Вложения

В списке pgsql-hackers по дате отправления: