Error while restoring tables from pgdump - Mailing list pgsql-sql

From Ramesh H R
Subject Error while restoring tables from pgdump
Date
Msg-id 3A82270C.BBD97F11@easi.soft.net
Whole thread Raw
List 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

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: PL/pgsql EXECUTE 'SELECT INTO ...'
Next
From: "Michael Miyabara-McCaskey"
Date:
Subject: RE: [ADMIN] FATAL 1: btree: items are out of order (leftmost 0, stack 48, update 2)