Hey all,
pg_dump fails to output necessary CREATE SEQUENCE statements unless
the SERIAL column is named "id" when called with the '-t tablename'
switch. When '-t' is not specified, the CREATE SEQUENCE statements
do get output.
wishing-I'd-noticed-this-Friday-nite-ly y'rs,
brent
Observeration:
sleepy:/usr/local/pg-7.2/bin
brent$ ./psql -c '\d test2'
Table "test2"
Column | Type | Modifiers
--------+-----------------------+-------------------------------------------------
n | character varying(32) |
i | integer | not null default nextval('"test2_i_seq"'::text)
Unique keys: test2_i_key
sleepy:/usr/local/pg-7.2/bin
brent$ ./pg_dump brent -t test2
--
-- Selected TOC Entries:
--
\connect - brent
--
-- TOC Entry ID 2 (OID 16571)
--
-- Name: test2 Type: TABLE Owner: brent
--
CREATE TABLE "test2" (
"n" character varying(32),
"i" integer DEFAULT nextval('"test2_i_seq"'::text) NOT NULL
);
--
-- Data for TOC Entry ID 4 (OID 16571)
--
-- Name: test2 Type: TABLE DATA Owner: brent
--
COPY "test2" FROM stdin;
\.
--
-- TOC Entry ID 3 (OID 16573)
--
-- Name: "test2_i_key" Type: INDEX Owner: brent
--
CREATE UNIQUE INDEX test2_i_key ON test2 USING btree (i);
--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman