pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ramesh H R <ramesh@easi.soft.net>
To: sqllist <pgsql-sql@postgresql.org>
Subject: Error while restoring tables from pgdump
Date: Thu, 08 Feb 2001 10:26:44 +0530
Message-ID: <3A82270C.BBD97F11@easi.soft.net> (raw)

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

Attachments:

ramesh.vcf (text/x-vcard, 405B) download 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

Message-ID: <3A82270C.BBD97F11@easi.soft.net>
Permalink:  ../3A82270C.BBD97F11@easi.soft.net/
Also on:    postgresql.org/message-id/3A82270C.BBD97F11@easi.soft.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: ramesh@easi.soft.net
  Subject: Re: Error while restoring tables from pgdump
  In-Reply-To: <3A82270C.BBD97F11@easi.soft.net>
  References: <3A82270C.BBD97F11@easi.soft.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox