Skip site navigation (1) Skip section navigation (2)

Re: migration still a problem

From: "P(dot) Jourdan" <pippo(at)videotron(dot)ca>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: migration still a problem
Date: 2002-04-14 18:49:36
Message-ID: 5.1.0.14.2.20020414144651.00a8fd88@pop.videotron.ca (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-novice by date

Next:From: April LDate: 2002-04-14 19:05:40
Subject: plpgsql and createlang?
Previous:From: Josh BerkusDate: 2002-04-14 18:25:46
Subject: Re: migration still a problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group