In case anyone cares, there is a bug in pg_dump in 7.0.3 when using the bit
fields.

eg: (This is a dump)

INSERT INTO "menu_plans" VALUES (7,'B''100000000''');
INSERT INTO "menu_plans" VALUES (6,'B''100000000''');
INSERT INTO "menu_plans" VALUES (8,'B''100000000''');

I think what's happening is that pg_dump is automatically putting quotes
around the fields, and escaping quotes in the string.  Strangely enough, if
this dump is restored then you get your original bitset back, with a zero
appended to each end!  Has this been fixed in 7.1?

Actually, I think that in 7.0.3's parser implementation they should be
dumped as :

INSERT INTO "menu_plans" VALUES (7,'b100000000');
INSERT INTO "menu_plans" VALUES (6,'b100000000');
INSERT INTO "menu_plans" VALUES (8,'b100000000');

--
Christopher Kings-Lynne
Family Health Network (ACN 089 639 243)


Fri, 9 Mar 2001 12:37:18 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
7.0.3 Bitset dumping
Christopher Kings-Lynne writes:

> In case anyone cares, there is a bug in pg_dump in 7.0.3 when using the bit
> fields.

There are no bit fields in 7.0, at least no officially.  7.1 does support
them.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Fri, 9 Mar 2001 17:17:12 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: 7.0.3 Bitset dumping