Received: from easi.soft.net. (server.easi.soft.net [164.164.23.5]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f184uSx40441 for ; Wed, 7 Feb 2001 23:56:29 -0500 (EST) (envelope-from ramesh@easi.soft.net) Received: from easi.soft.net (ramesh@pcl63.easi.soft.net [100.0.0.163]) by easi.soft.net. (8.8.8/8.8.8) with ESMTP id KAA05849 for ; Thu, 8 Feb 2001 10:28:18 +0530 Message-ID: <3A82270C.BBD97F11@easi.soft.net> Date: Thu, 08 Feb 2001 10:26:44 +0530 From: Ramesh H R Organization: EASi Technologies X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i586) X-Accept-Language: en MIME-Version: 1.0 To: sqllist Subject: Error while restoring tables from pgdump Content-Type: multipart/mixed; boundary="------------11F1B2C976EDBD008AC0903B" X-Archive-Number: 200102/148 X-Sequence-Number: 1328 This is a multi-part message in MIME format. --------------11F1B2C976EDBD008AC0903B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hai, I have taken pgdump of a table which contains "serial" datatype. When i try to populate it into another database the sequence is not created. Why it is so? Please help me, Ramesh I took pgdump of the table using pg_dump olddb -t grms_filter_table_list > tables.pgdump i restored the table in another database using cat tables.pgdump | psql newdb i have the table in new database whose str is as follows Table "grms_filter_table_list" Attribute | Type | Modifier ------------+-------------+------------------------------------------------------------------- table_id | integer | not null default nextval('grms_filter_table__table_id_seq'::text) table_name | varchar(50) | disp_as | varchar(50) | Index: grms_filter_table__table_id_key when i try to insert new record, i get following error ERROR: Relation 'grms_filter_table__table_id_seq' does not exist Please advice me as how to take the pgdump with serial data type (ie table which has sequence) Thanks in advance Ramesh HR --------------11F1B2C976EDBD008AC0903B Content-Type: text/x-vcard; charset=us-ascii; name="ramesh.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Ramesh H R Content-Disposition: attachment; filename="ramesh.vcf" begin:vcard n:HR;Ramesh tel;fax:6675274 tel;home:91-0821-498071 tel;work:91-080-6601086/ 91-080-6602365/ 91-080-6672984 Extn. 155 x-mozilla-html:FALSE url:www.easi.soft.net org:EASi Technologies;IT Services version:2.1 email;internet:ramesh@easi.soft.net adr;quoted-printable:;;213, 3rd Main,=0D=0A4th Cross,=0D=0AChamrajpet ;Bangalore;Karnataka;560 018;India x-mozilla-cpt:;20992 fn:Ramesh HR end:vcard --------------11F1B2C976EDBD008AC0903B--