Error while restoring tables from pgdump

From: Ramesh H R <ramesh(at)easi(dot)soft(dot)net>
To: sqllist <pgsql-sql(at)postgresql(dot)org>
Subject: Error while restoring tables from pgdump
Date: 2001-02-08 04:56:44
Message-ID: 3A82270C.BBD97F11@easi.soft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Attachment Content-Type Size
ramesh.vcf text/x-vcard 406 bytes

Browse pgsql-sql by date

  From Date Subject
Next Message manjul katare 2001-02-08 04:57:26 sql query
Previous Message Josh Berkus 2001-02-08 04:49:52 Re: PL/pgsql EXECUTE 'SELECT INTO ...'