Bug in pg_restore ... ? - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Bug in pg_restore ... ?
Date
Msg-id 20050609161932.E34152@ganymede.hub.org
Whole thread Raw
Responses Re: Bug in pg_restore ... ?
List pgsql-hackers
I thought it was supposed to know "proper ordering" for doing the restore, 
but:

%bin/pg_restore -d data ../db/data.dump | & tee data.data.log
pg_restore: NOTICE:  CREATE TABLE will create implicit sequence "resellers_id_seq" for "serial" column "resellers.id"
pg_restore: NOTICE:  CREATE TABLE will create implicit sequence "reseller_cookies_id_seq" for "serial" column
"reseller_cookies.id"
pg_restore: NOTICE:  CREATE TABLE will create implicit sequence "transactions_id_seq" for "serial" column
"transactions.id"
pg_restore: NOTICE:  CREATE TABLE will create implicit sequence "users_id_seq" for "serial" column "users.id"
pg_restore: NOTICE:  CREATE TABLE will create implicit sequence "user_cookies_id_seq" for "serial" column
"user_cookies.id"
pg_restore: NOTICE:  CREATE TABLE will create implicit sequence "packages_id_seq" for "serial" column "packages.id"
pg_restore: NOTICE:  CREATE TABLE will create implicit sequence "billing_events_id_seq" for "serial" column
"billing_events.id"
pg_restore: NOTICE:  CREATE TABLE will create implicit sequence "data_id_seq" for "serial" column "blogs.id"
pg_restore: NOTICE:  CREATE TABLE will create implicit sequence "groups_id_seq" for "serial" column "groups.id"
pg_restore: NOTICE:  CREATE TABLE will create implicit sequence "categories_id_seq" for "serial" column
"categories.id"
pg_restore: NOTICE:  CREATE TABLE will create implicit sequence "articles_id_seq" for "serial" column "articles.id"
pg_restore: [archiver (db)] could not execute query: ERROR:  type "tsvector" does not exist

tsvector is defined in the dump, but appears to be *after* the TABLES 
themselves are created ... basically, shouldn't functions be created 
before TABLES are?

This is with pg_restore from 7.4.6 ... so this might be something that has 
been fixed already ... but figured I'd make sure it wasn't just me doing 
something wrong ...


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pg_config --configure ...
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Bug in pg_restore ... ?