pg_dump and sequences
От | Achilleus Mantzios |
---|---|
Тема | pg_dump and sequences |
Дата | |
Msg-id | Pine.LNX.4.44.0207231105320.21717-100000@matrix.gatewaynet.com обсуждение исходный текст |
Ответ на | Free 4GL Compiler, Informix-Postgress support (ecitizen@hotmail.com (Ecitizen)) |
Ответы |
Re: pg_dump and sequences
|
Список | pgsql-sql |
Hi, i am using postgreSQL 7.2.1 on a redhat 7.2 (kernel 2.4.9-31,glibc-2.2.4-24). It seems that pg_dump -t "tablename" dumps correctly the sequence of a table's column,when the column is named after "id". For example, dynacom=# CREATE TABLE foo2 (fid serial NOT NULL UNIQUE PRIMARY KEY,id serial); [postgres@pc216 ~]% pg_dump -t foo2 > foo2DUMP.sql [postgres@pc216 ~]% cat foo2DUMP.sql -- -- Selected TOC Entries: -- \connect - postgres -- -- TOC Entry ID 2 (OID 2009757) -- -- Name: foo2_id_seq Type: SEQUENCE Owner: postgres -- CREATE SEQUENCE "foo2_id_seq" start 1 increment 1 maxvalue 9223372036854775807 minvalue 1 cache 1; -- -- TOC Entry ID 4 (OID 2009759) -- -- Name: foo2 Type: TABLE Owner: postgres -- CREATE TABLE "foo2" ( "fid" integer DEFAULT nextval('"foo2_fid_seq"'::text) NOT NULL, "id" integer DEFAULT nextval('"foo2_id_seq"'::text)NOT NULL, Constraint "foo2_pkey" Primary Key ("fid") ); -- -- Data for TOC Entry ID 6 (OID 2009759) -- -- Name: foo2 Type: TABLE DATA Owner: postgres -- COPY "foo2" FROM stdin; \. -- -- TOC Entry ID 5 (OID 2009762) -- -- Name: "foo2_id_key" Type: INDEX Owner: postgres -- CREATE UNIQUE INDEX foo2_id_key ON foo2 USING btree (id); -- -- TOC Entry ID 3 (OID 2009757) -- -- Name: foo2_id_seq Type: SEQUENCE SET Owner: postgres -- SELECT setval ('"foo2_id_seq"', 1, false); -- Any ideas?? Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr
В списке pgsql-sql по дате отправления: