Search Postgresql Archives
pg_dump seg fault on sequences
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: "pgsql general" <pgsql-general@xxxxxxxxxxxxxx>
- Subject: pg_dump seg fault on sequences
- From: "Michael Nolan" <htfoot@xxxxxxxxx>
- Date: Sat, 14 Apr 2007 14:07:09 -0500
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=OKd/igtuKOq0kNURxnF1LMQWFL330xNviEgT37aHtBMY1dD6ihfKEWqsHdT3yRfrXEtJ8e8YqvRL5GAwmvTGcxoHZrk6rrfZ/C39+7yfq/iVxxYTBdauVINGLofbU/ByYDLWFodZaF+4rWN3jJR+k9t3lFufEMpRNWVCcER2nU8=
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]