Search Postgresql Archives

pg_dump seg fault on sequences

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux