From: | "Michael Nolan" <htfoot(at)gmail(dot)com> |
---|---|
To: | "pgsql general" <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_dump seg fault on sequences |
Date: | 2007-04-14 19:07:09 |
Message-ID: | 4abad0eb0704141207o24830860gbf2cfbf243596b9b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)kingside testing]$ /usr/local/pgsql/bin/pg_dump -t seqtest_field2_seq
-U uscf uscf
Password:
Segmentation fault
--
Mike Nolan
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2007-04-14 19:25:49 | Re: postgresql 8.1.4 to 8.2.3 |
Previous Message | Mason Hale | 2007-04-14 18:51:27 | Re: error creating/setting sequence, pg_dump / pg_restore 8.1.5 |