Re: migration still a problem
От | P. Jourdan |
---|---|
Тема | Re: migration still a problem |
Дата | |
Msg-id | 5.1.0.14.2.20020414144651.00a8fd88@pop.videotron.ca обсуждение исходный текст |
Ответ на | Re: migration still a problem ("Josh Berkus" <josh@agliodbs.com>) |
Список | pgsql-novice |
At 11:25 AM 4/14/2002 -0700, you wrote: >Next step: First, copy the original file in case your text editor >causes problems. Second, copy the, say, first 30 lines of the file and >post them with your next reply. That should be enough to tell if it's >a pg_dump or pg_dumpall file. > >-Josh Here are the first 25 lines: Username: Password: \connect - med CREATE SEQUENCE "category_category_id_seq" start 60 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"category_category_id_seq"'); CREATE SEQUENCE "contact_contact_id_seq" start 576 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"contact_contact_id_seq"'); CREATE SEQUENCE "currency_rates_currency_rate" start 21 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"currency_rates_currency_rate"'); CREATE SEQUENCE "customer_customer_id_seq" start 49 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"customer_customer_id_seq"'); CREATE SEQUENCE "flow_flow_id_seq" start 5 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"flow_flow_id_seq"'); CREATE SEQUENCE "news_news_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"news_news_id_seq"'); CREATE SEQUENCE "order_status_order_status_id" start 7 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"order_status_order_status_id"'); CREATE SEQUENCE "order_types_order_type_id_se" start 3 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"order_types_order_type_id_se"'); CREATE SEQUENCE "orders_order_id_seq" start 4 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"orders_order_id_seq"'); CREATE SEQUENCE "pages_pages_id_seq" start 26 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"pages_pages_id_seq"'); CREATE SEQUENCE "price_types_price_type_id_se" start 5 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; SELECT nextval ('"price_types_price_type_id_se"'); Philip Jourdan
В списке pgsql-novice по дате отправления: