pg_dump seg fault on sequences

Поиск
Список
Период
Сортировка
От Michael Nolan
Тема pg_dump seg fault on sequences
Дата
Msg-id 4abad0eb0704141207o24830860gbf2cfbf243596b9b@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump seg fault on sequences
Список pgsql-general
I've narrowed down the conditions under which pg_dump in 8.2.3 is creating a segmentation fault. 

It appears to happen only when dumping a sequence that is created for a serial data element.


uscf=> create table public.seqtest
uscf-> (field1 text,
uscf(> field2 serial);
create table public.seqtest
(field1 text,
field2 serial);
NOTICE:  CREATE TABLE will create implicit sequence "seqtest_field2_seq" for ser
ial column "seqtest.field2"
CREATE TABLE
Time: 222.913 ms
uscf=> insert into seqtest values ('x');
insert into seqtest values ('x');
INSERT 0 1
Time: 14.065 ms
uscf=> select * from seqtest;
select * from seqtest;
field1 | field2
--------+--------
x      |      1
(1 row)

[uscf@kingside testing]$ /usr/local/pgsql/bin/pg_dump -t seqtest_field2_seq -U uscf uscf
Password:
Segmentation fault
--
Mike Nolan





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

Предыдущее
От: "Mason Hale"
Дата:
Сообщение: Re: error creating/setting sequence, pg_dump / pg_restore 8.1.5
Следующее
От: Erik Jones
Дата:
Сообщение: Re: postgresql 8.1.4 to 8.2.3