From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Bug in pg_restore ... ? |
Date: | 2005-06-09 19:22:43 |
Message-ID: | 20050609161932.E34152@ganymede.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2005-06-09 19:46:18 | Re: Bug in pg_restore ... ? |
Previous Message | Joshua D. Drake | 2005-06-09 18:54:57 | Re: Request for support for GIST enhancements |