in reply to Re: dbicdump not importing the full table (Postgres)
in thread dbicdump not importing the full table (Postgres)
dbicdump: Hmmm - Ubuntu has packaged 0.07010, and CPAN has 0.07023... I'll have a look at the changes file!
pg_dump: I've removed a pile of PostGIS stuff from this (I think I got it all....)
-- -- PostgreSQL database dump -- SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: networks; Type: TABLE; Schema: public; Owner: oarj; Tablespac +e: -- CREATE TABLE networks ( id integer NOT NULL, inetnum text NOT NULL, system_url text, hex_lower character varying(20) NOT NULL, hex_upper character varying(20) NOT NULL, dec_lower inet NOT NULL, dec_upper inet NOT NULL ); ALTER TABLE public.networks OWNER TO oarj; -- -- Name: TABLE networks; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE networks IS 'Network Objects'; -- -- Name: Sources_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE "Sources_id_seq" INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public."Sources_id_seq" OWNER TO oarj; -- -- Name: Sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owne +r: oarj -- ALTER SEQUENCE "Sources_id_seq" OWNED BY networks.id; -- -- Name: comment; Type: TABLE; Schema: public; Owner: oarj; Tablespace +: -- CREATE TABLE comment ( tbl character varying(20) NOT NULL, table_id integer, text text NOT NULL, pri boolean, id integer NOT NULL ); ALTER TABLE public.comment OWNER TO oarj; -- -- Name: TABLE comment; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE comment IS 'Descriptions and comments for Objects'; -- -- Name: comment_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE comment_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.comment_id_seq OWNER TO oarj; -- -- Name: comment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owne +r: oarj -- ALTER SEQUENCE comment_id_seq OWNED BY comment.id; -- -- Name: contentlinks; Type: TABLE; Schema: public; Owner: oarj; Table +space: -- CREATE TABLE contentlinks ( content_id integer NOT NULL, repo_id integer NOT NULL ); ALTER TABLE public.contentlinks OWNER TO oarj; -- -- Name: TABLE contentlinks; Type: COMMENT; Schema: public; Owner: oar +j -- COMMENT ON TABLE contentlinks IS 'Mapping the relationship between Rep +ositories and the Content Type they accept'; -- -- Name: contenttypes; Type: TABLE; Schema: public; Owner: oarj; Table +space: -- CREATE TABLE contenttypes ( id integer NOT NULL, text text NOT NULL ); ALTER TABLE public.contenttypes OWNER TO oarj; -- -- Name: TABLE contenttypes; Type: COMMENT; Schema: public; Owner: oar +j -- COMMENT ON TABLE contenttypes IS 'The Content Types repositories accep +t'; -- -- Name: country; Type: TABLE; Schema: public; Owner: oarj; Tablespace +: -- CREATE TABLE country ( code character varying(20) NOT NULL, text text NOT NULL ); ALTER TABLE public.country OWNER TO oarj; -- -- Name: TABLE country; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE country IS 'The full names for country codes'; -- -- Name: externalids; Type: TABLE; Schema: public; Owner: oarj; Tables +pace: -- CREATE TABLE externalids ( tbl character varying(20) NOT NULL, table_id integer NOT NULL, source_id integer NOT NULL, code text NOT NULL, "Pri" boolean ); ALTER TABLE public.externalids OWNER TO oarj; -- -- Name: TABLE externalids; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE externalids IS 'Authoritative database IDs (if they h +ave them) Note: External IDs may not always be numbers, so we have "text", not " +integer" to store the code in.'; SET default_with_oids = true; -- -- Name: langlinks; Type: TABLE; Schema: public; Owner: oarj; Tablespa +ce: -- CREATE TABLE langlinks ( repo_id integer NOT NULL, lang_id integer NOT NULL ); ALTER TABLE public.langlinks OWNER TO oarj; -- -- Name: TABLE langlinks; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE langlinks IS 'Mapping the links between languages and + repositories'; -- -- Name: language; Type: TABLE; Schema: public; Owner: oarj; Tablespac +e: -- CREATE TABLE language ( id integer NOT NULL, text text NOT NULL, iso3_b character varying(3), iso3_t character varying(3), iso2 character varying(2) ); ALTER TABLE public.language OWNER TO oarj; -- -- Name: TABLE language; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE language IS 'Languages and their various codes'; -- -- Name: language_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE language_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.language_id_seq OWNER TO oarj; -- -- Name: language_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Own +er: oarj -- ALTER SEQUENCE language_id_seq OWNED BY language.id; -- -- Name: manager; Type: TABLE; Schema: public; Owner: oarj; Tablespace +: -- CREATE TABLE manager ( id integer NOT NULL, name text, jobtitle text, email text, phone text ); ALTER TABLE public.manager OWNER TO oarj; -- -- Name: TABLE manager; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE manager IS 'Managers (of repositories)'; -- -- Name: manager_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE manager_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.manager_id_seq OWNER TO oarj; -- -- Name: manager_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owne +r: oarj -- ALTER SEQUENCE manager_id_seq OWNED BY manager.id; -- -- Name: manager_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE manager_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.manager_seq OWNER TO oarj; -- -- Name: SEQUENCE manager_seq; Type: COMMENT; Schema: public; Owner: o +arj -- COMMENT ON SEQUENCE manager_seq IS 'IDs for Manager Objects'; -- -- Name: managerlinks; Type: TABLE; Schema: public; Owner: oarj; Table +space: -- CREATE TABLE managerlinks ( repo_id integer NOT NULL, manager_id integer NOT NULL ); ALTER TABLE public.managerlinks OWNER TO oarj; -- -- Name: TABLE managerlinks; Type: COMMENT; Schema: public; Owner: oar +j -- COMMENT ON TABLE managerlinks IS 'Mapping the links between Managers a +nd the repositories they manage'; -- -- Name: name; Type: TABLE; Schema: public; Owner: oarj; Tablespace: -- CREATE TABLE name ( tbl character varying(20) NOT NULL, table_id integer, source_id integer, name text, acronym text, npref boolean DEFAULT false, id integer NOT NULL, lang_id integer, pri boolean ); ALTER TABLE public.name OWNER TO oarj; -- -- Name: TABLE name; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE name IS 'Names for things'; -- -- Name: COLUMN name.npref; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON COLUMN name.npref IS 'Name Preferred'; -- -- Name: name2url; Type: TABLE; Schema: public; Owner: oarj; Tablespac +e: -- CREATE TABLE name2url ( name_id integer NOT NULL, url_id integer NOT NULL ); ALTER TABLE public.name2url OWNER TO oarj; -- -- Name: TABLE name2url; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE name2url IS 'Links names and urls'; -- -- Name: name_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE name_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.name_id_seq OWNER TO oarj; -- -- Name: name_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: +oarj -- ALTER SEQUENCE name_id_seq OWNED BY name.id; -- -- Name: net_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE net_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.net_seq OWNER TO oarj; -- -- Name: SEQUENCE net_seq; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON SEQUENCE net_seq IS 'IDs for Net Objects'; -- -- Name: netmaps; Type: TABLE; Schema: public; Owner: oarj; Tablespace +: -- CREATE TABLE netmaps ( net_id integer NOT NULL, org_id integer NOT NULL ); ALTER TABLE public.netmaps OWNER TO oarj; -- -- Name: TABLE netmaps; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE netmaps IS 'Network Objects'; -- -- Name: sources; Type: TABLE; Schema: public; Owner: oarj; Tablespace +: -- CREATE TABLE sources ( id integer NOT NULL, name text, harvest_point text ); ALTER TABLE public.sources OWNER TO oarj; -- -- Name: TABLE sources; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE sources IS 'Authoritative sources'; -- -- Name: COLUMN sources.harvest_point; Type: COMMENT; Schema: public; +Owner: oarj -- COMMENT ON COLUMN sources.harvest_point IS 'The IRI to harvest from th +is source (if there is one)'; -- -- Name: networks_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE networks_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.networks_id_seq OWNER TO oarj; -- -- Name: networks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Own +er: oarj -- ALTER SEQUENCE networks_id_seq OWNED BY sources.id; -- -- Name: opstatus; Type: TABLE; Schema: public; Owner: oarj; Tablespac +e: -- CREATE TABLE opstatus ( id integer NOT NULL, text text ); ALTER TABLE public.opstatus OWNER TO oarj; -- -- Name: opstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE opstatus_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.opstatus_id_seq OWNER TO oarj; -- -- Name: opstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Own +er: oarj -- ALTER SEQUENCE opstatus_id_seq OWNED BY opstatus.id; -- -- Name: org; Type: TABLE; Schema: public; Owner: oarj; Tablespace: -- CREATE TABLE org ( id integer NOT NULL, system_url text, oarj2_id integer, lat real, long real, city character varying(256), country character varying(256), postponed boolean, failed boolean, notes text ); ALTER TABLE public.org OWNER TO oarj; -- -- Name: TABLE org; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE org IS 'Organisation Objects'; -- -- Name: org_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE org_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.org_id_seq OWNER TO oarj; -- -- Name: org_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: o +arj -- ALTER SEQUENCE org_id_seq OWNED BY org.id; -- -- Name: org_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE org_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.org_seq OWNER TO oarj; -- -- Name: SEQUENCE org_seq; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON SEQUENCE org_seq IS 'IDs for Org Objects'; -- -- Name: parents; Type: TABLE; Schema: public; Owner: oarj; Tablespace +: -- CREATE TABLE parents ( parent_id integer NOT NULL, child_id integer NOT NULL ); ALTER TABLE public.parents OWNER TO oarj; -- -- Name: TABLE parents; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE parents IS 'Mapping the Parent/Child relationships be +tween organisations'; -- -- Name: policy; Type: TABLE; Schema: public; Owner: oarj; Tablespace: + -- CREATE TABLE policy ( id integer NOT NULL, repo_id integer NOT NULL, type_id integer, grade_id integer, item_xml text NOT NULL ); ALTER TABLE public.policy OWNER TO oarj; -- -- Name: TABLE policy; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE policy IS 'Repository Policies'; -- -- Name: policy_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE policy_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.policy_id_seq OWNER TO oarj; -- -- Name: policy_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner +: oarj -- ALTER SEQUENCE policy_id_seq OWNED BY policy.id; -- -- Name: policy_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE policy_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.policy_seq OWNER TO oarj; -- -- Name: SEQUENCE policy_seq; Type: COMMENT; Schema: public; Owner: oa +rj -- COMMENT ON SEQUENCE policy_seq IS 'IDs for Policy Objects'; -- -- Name: policygrade; Type: TABLE; Schema: public; Owner: oarj; Tables +pace: -- CREATE TABLE policygrade ( id integer NOT NULL, text text NOT NULL ); ALTER TABLE public.policygrade OWNER TO oarj; -- -- Name: TABLE policygrade; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE policygrade IS 'Policy grades'; -- -- Name: policytype; Type: TABLE; Schema: public; Owner: oarj; Tablesp +ace: -- CREATE TABLE policytype ( id integer NOT NULL, text text NOT NULL ); ALTER TABLE public.policytype OWNER TO oarj; -- -- Name: TABLE policytype; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE policytype IS 'Policy Types'; -- -- Name: ref_string; Type: TABLE; Schema: public; Owner: oarj; Tablesp +ace: -- CREATE TABLE ref_string ( tbl character varying(20) NOT NULL, table_id integer NOT NULL, text text NOT NULL ); ALTER TABLE public.ref_string OWNER TO oarj; -- -- Name: TABLE ref_string; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE ref_string IS 'Reference strings for objects'; -- -- Name: repo; Type: TABLE; Schema: public; Owner: oarj; Tablespace: -- CREATE TABLE repo ( id integer NOT NULL, system_url text, oaibaseurl text, softwarename text, softwareversion text, postaddress text, countrycode character varying(20), phone text, fax text, lat real, long real, mandate boolean DEFAULT false NOT NULL, fulltext boolean DEFAULT false NOT NULL, openaccess boolean DEFAULT false NOT NULL, opstatus integer ); ALTER TABLE public.repo OWNER TO oarj; -- -- Name: TABLE repo; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE repo IS 'Repository Objects'; -- -- Name: repo_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE repo_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.repo_id_seq OWNER TO oarj; -- -- Name: repo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: +oarj -- ALTER SEQUENCE repo_id_seq OWNED BY repo.id; -- -- Name: repo_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE repo_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.repo_seq OWNER TO oarj; -- -- Name: SEQUENCE repo_seq; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON SEQUENCE repo_seq IS 'IDs for Repo Objects'; -- -- Name: repotype; Type: TABLE; Schema: public; Owner: oarj; Tablespac +e: -- CREATE TABLE repotype ( text text NOT NULL, id integer NOT NULL ); ALTER TABLE public.repotype OWNER TO oarj; -- -- Name: TABLE repotype; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE repotype IS 'Repository types'; -- -- Name: repotype_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE repotype_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.repotype_id_seq OWNER TO oarj; -- -- Name: repotype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Own +er: oarj -- ALTER SEQUENCE repotype_id_seq OWNED BY repotype.id; -- -- Name: sitelinks; Type: TABLE; Schema: public; Owner: oarj; Tablespa +ce: -- CREATE TABLE sitelinks ( repo_id integer NOT NULL, org_id integer NOT NULL ); ALTER TABLE public.sitelinks OWNER TO oarj; -- -- Name: TABLE sitelinks; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE sitelinks IS 'Mapping the Repository/Organisation rel +ationship'; -- -- Name: source_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE source_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.source_seq OWNER TO oarj; -- -- Name: SEQUENCE source_seq; Type: COMMENT; Schema: public; Owner: oa +rj -- COMMENT ON SEQUENCE source_seq IS 'IDs for Source Objects'; -- -- Name: sourcelinks; Type: TABLE; Schema: public; Owner: oarj; Tables +pace: -- CREATE TABLE sourcelinks ( repo_id integer NOT NULL, source_id integer NOT NULL ); ALTER TABLE public.sourcelinks OWNER TO oarj; -- -- Name: TABLE sourcelinks; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE sourcelinks IS 'Mapping the links between an Object a +nd the Source Authority'; -- -- Name: spatial_ref_sys; Type: TABLE; Schema: public; Owner: oarj; Ta +blespace: -- CREATE TABLE spatial_ref_sys ( srid integer NOT NULL, auth_name character varying(256), auth_srid integer, srtext character varying(2048), proj4text character varying(2048) ); ALTER TABLE public.spatial_ref_sys OWNER TO oarj; -- -- Name: subjectlinks; Type: TABLE; Schema: public; Owner: oarj; Table +space: -- CREATE TABLE subjectlinks ( repo_id integer NOT NULL, subject_code character varying(20) NOT NULL ); ALTER TABLE public.subjectlinks OWNER TO oarj; -- -- Name: TABLE subjectlinks; Type: COMMENT; Schema: public; Owner: oar +j -- COMMENT ON TABLE subjectlinks IS 'Mapping the relationships between Re +positories and the Subjects they cover'; -- -- Name: subjects; Type: TABLE; Schema: public; Owner: oarj; Tablespac +e: -- CREATE TABLE subjects ( code character varying(20) NOT NULL, text text NOT NULL ); ALTER TABLE public.subjects OWNER TO oarj; -- -- Name: TABLE subjects; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE subjects IS 'The Subject terms used by the Authoritat +ive Sources'; -- -- Name: superceeds; Type: TABLE; Schema: public; Owner: oarj; Tablesp +ace: -- CREATE TABLE superceeds ( tbl character varying(20) NOT NULL, old_id integer NOT NULL, new_id integer NOT NULL ); ALTER TABLE public.superceeds OWNER TO oarj; -- -- Name: sword; Type: TABLE; Schema: public; Owner: oarj; Tablespace: -- CREATE TABLE sword ( repo_id integer NOT NULL, servicedocument text, username character varying(24), password character varying(24), protocol character varying(24), host text, collection text ); ALTER TABLE public.sword OWNER TO oarj; -- -- Name: TABLE sword; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE sword IS 'SWORD details'; -- -- Name: typelinks; Type: TABLE; Schema: public; Owner: oarj; Tablespa +ce: -- CREATE TABLE typelinks ( repo_id integer NOT NULL, type_id integer NOT NULL ); ALTER TABLE public.typelinks OWNER TO oarj; -- -- Name: TABLE typelinks; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE typelinks IS 'Mapping the links between Repositories +and their Types'; -- -- Name: urls; Type: TABLE; Schema: public; Owner: oarj; Tablespace: -- CREATE TABLE urls ( id integer NOT NULL, tbl character varying(20) NOT NULL, table_id integer, url text NOT NULL, pri boolean, count_success integer, count_fails integer, last_check_good boolean, host_alive boolean, base_uri text, http_code integer, date_checked date ); ALTER TABLE public.urls OWNER TO oarj; -- -- Name: TABLE urls; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE urls IS 'URLs for objects'; -- -- Name: urls_id_seq; Type: SEQUENCE; Schema: public; Owner: oarj -- CREATE SEQUENCE urls_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE public.urls_id_seq OWNER TO oarj; -- -- Name: urls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: +oarj -- ALTER SEQUENCE urls_id_seq OWNED BY urls.id; -- -- Name: xml; Type: TABLE; Schema: public; Owner: oarj; Tablespace: -- CREATE TABLE xml ( source_id integer NOT NULL, xml text NOT NULL ); ALTER TABLE public.xml OWNER TO oarj; -- -- Name: TABLE xml; Type: COMMENT; Schema: public; Owner: oarj -- COMMENT ON TABLE xml IS 'Full XML records, to test for changes. We don''t need to know the repo or anything: if the XML we have to pro +cess matches a record, then we can skip to the next record.'; -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY comment ALTER COLUMN id SET DEFAULT nextval('comment_ +id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY language ALTER COLUMN id SET DEFAULT nextval('languag +e_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY manager ALTER COLUMN id SET DEFAULT nextval('manager_ +id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY name ALTER COLUMN id SET DEFAULT nextval('name_id_seq +'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY networks ALTER COLUMN id SET DEFAULT nextval('"Source +s_id_seq"'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY opstatus ALTER COLUMN id SET DEFAULT nextval('opstatu +s_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY org ALTER COLUMN id SET DEFAULT nextval('org_id_seq': +:regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY policy ALTER COLUMN id SET DEFAULT nextval('policy_id +_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY repo ALTER COLUMN id SET DEFAULT nextval('repo_id_seq +'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY repotype ALTER COLUMN id SET DEFAULT nextval('repotyp +e_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY sources ALTER COLUMN id SET DEFAULT nextval('networks +_id_seq'::regclass); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: oarj -- ALTER TABLE ONLY urls ALTER COLUMN id SET DEFAULT nextval('urls_id_seq +'::regclass); -- -- Name: comment_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; +Tablespace: -- ALTER TABLE ONLY comment ADD CONSTRAINT comment_pkey PRIMARY KEY (id); -- -- Name: contentlinks_pkey; Type: CONSTRAINT; Schema: public; Owner: o +arj; Tablespace: -- ALTER TABLE ONLY contentlinks ADD CONSTRAINT contentlinks_pkey PRIMARY KEY (content_id, repo_id) +; -- -- Name: contenttypes_pkey; Type: CONSTRAINT; Schema: public; Owner: o +arj; Tablespace: -- ALTER TABLE ONLY contenttypes ADD CONSTRAINT contenttypes_pkey PRIMARY KEY (id); -- -- Name: country_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; +Tablespace: -- ALTER TABLE ONLY country ADD CONSTRAINT country_pkey PRIMARY KEY (code); -- -- Name: externalids_tbl_key; Type: CONSTRAINT; Schema: public; Owner: + oarj; Tablespace: -- ALTER TABLE ONLY externalids ADD CONSTRAINT externalids_tbl_key UNIQUE (tbl, table_id, source_i +d, code); -- -- Name: langlinks_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj +; Tablespace: -- ALTER TABLE ONLY langlinks ADD CONSTRAINT langlinks_pkey PRIMARY KEY (repo_id, lang_id); -- -- Name: language_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; + Tablespace: -- ALTER TABLE ONLY language ADD CONSTRAINT language_pkey PRIMARY KEY (id); -- -- Name: manager_name_key; Type: CONSTRAINT; Schema: public; Owner: oa +rj; Tablespace: -- ALTER TABLE ONLY manager ADD CONSTRAINT manager_name_key UNIQUE (name, jobtitle, email, pho +ne); -- -- Name: manager_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; +Tablespace: -- ALTER TABLE ONLY manager ADD CONSTRAINT manager_pkey PRIMARY KEY (id); -- -- Name: managerlinks_pkey; Type: CONSTRAINT; Schema: public; Owner: o +arj; Tablespace: -- ALTER TABLE ONLY managerlinks ADD CONSTRAINT managerlinks_pkey PRIMARY KEY (repo_id, manager_id) +; -- -- Name: name2url_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; + Tablespace: -- ALTER TABLE ONLY name2url ADD CONSTRAINT name2url_pkey PRIMARY KEY (name_id, url_id); -- -- Name: name_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; Tab +lespace: -- ALTER TABLE ONLY name ADD CONSTRAINT name_pkey PRIMARY KEY (id); -- -- Name: netmaps_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; +Tablespace: -- ALTER TABLE ONLY netmaps ADD CONSTRAINT netmaps_pkey PRIMARY KEY (net_id, org_id); -- -- Name: networks_dec_lower_key; Type: CONSTRAINT; Schema: public; Own +er: oarj; Tablespace: -- ALTER TABLE ONLY networks ADD CONSTRAINT networks_dec_lower_key UNIQUE (dec_lower, dec_upper +); -- -- Name: networks_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; + Tablespace: -- ALTER TABLE ONLY networks ADD CONSTRAINT networks_pkey PRIMARY KEY (id); -- -- Name: opstatus_id_key; Type: CONSTRAINT; Schema: public; Owner: oar +j; Tablespace: -- ALTER TABLE ONLY opstatus ADD CONSTRAINT opstatus_id_key UNIQUE (id); -- -- Name: opstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; + Tablespace: -- ALTER TABLE ONLY opstatus ADD CONSTRAINT opstatus_pkey PRIMARY KEY (id); -- -- Name: org_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; Tabl +espace: -- ALTER TABLE ONLY org ADD CONSTRAINT org_pkey PRIMARY KEY (id); -- -- Name: parents_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; +Tablespace: -- ALTER TABLE ONLY parents ADD CONSTRAINT parents_pkey PRIMARY KEY (parent_id, child_id); -- -- Name: policy_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; T +ablespace: -- ALTER TABLE ONLY policy ADD CONSTRAINT policy_pkey PRIMARY KEY (id); -- -- Name: policygrade_pkey; Type: CONSTRAINT; Schema: public; Owner: oa +rj; Tablespace: -- ALTER TABLE ONLY policygrade ADD CONSTRAINT policygrade_pkey PRIMARY KEY (id); -- -- Name: policytype_pkey; Type: CONSTRAINT; Schema: public; Owner: oar +j; Tablespace: -- ALTER TABLE ONLY policytype ADD CONSTRAINT policytype_pkey PRIMARY KEY (id); -- -- Name: repo_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; Tab +lespace: -- ALTER TABLE ONLY repo ADD CONSTRAINT repo_pkey PRIMARY KEY (id); -- -- Name: repotype_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; + Tablespace: -- ALTER TABLE ONLY repotype ADD CONSTRAINT repotype_pkey PRIMARY KEY (id); -- -- Name: sitelinks_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj +; Tablespace: -- ALTER TABLE ONLY sitelinks ADD CONSTRAINT sitelinks_pkey PRIMARY KEY (repo_id, org_id); -- -- Name: sourcelinks_pkey; Type: CONSTRAINT; Schema: public; Owner: oa +rj; Tablespace: -- ALTER TABLE ONLY sourcelinks ADD CONSTRAINT sourcelinks_pkey PRIMARY KEY (repo_id, source_id); -- -- Name: sources_name_key; Type: CONSTRAINT; Schema: public; Owner: oa +rj; Tablespace: -- ALTER TABLE ONLY sources ADD CONSTRAINT sources_name_key UNIQUE (name); -- -- Name: sources_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; +Tablespace: -- ALTER TABLE ONLY sources ADD CONSTRAINT sources_pkey PRIMARY KEY (id); -- -- Name: spatial_ref_sys_pkey; Type: CONSTRAINT; Schema: public; Owner +: oarj; Tablespace: -- ALTER TABLE ONLY spatial_ref_sys ADD CONSTRAINT spatial_ref_sys_pkey PRIMARY KEY (srid); -- -- Name: subjectlinks_pkey; Type: CONSTRAINT; Schema: public; Owner: o +arj; Tablespace: -- ALTER TABLE ONLY subjectlinks ADD CONSTRAINT subjectlinks_pkey PRIMARY KEY (repo_id, subject_cod +e); -- -- Name: subjects_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; + Tablespace: -- ALTER TABLE ONLY subjects ADD CONSTRAINT subjects_pkey PRIMARY KEY (code); -- -- Name: superceeds_pkey; Type: CONSTRAINT; Schema: public; Owner: oar +j; Tablespace: -- ALTER TABLE ONLY superceeds ADD CONSTRAINT superceeds_pkey PRIMARY KEY (tbl, old_id, new_id); -- -- Name: typelinks_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj +; Tablespace: -- ALTER TABLE ONLY typelinks ADD CONSTRAINT typelinks_pkey PRIMARY KEY (repo_id, type_id); -- -- Name: urls_pkey; Type: CONSTRAINT; Schema: public; Owner: oarj; Tab +lespace: -- ALTER TABLE ONLY urls ADD CONSTRAINT urls_pkey PRIMARY KEY (id); -- -- Name: comment_table_idx; Type: INDEX; Schema: public; Owner: oarj; +Tablespace: -- CREATE INDEX comment_table_idx ON comment USING btree (table_id, tbl); -- -- Name: contentlinks_content_idx; Type: INDEX; Schema: public; Owner: + oarj; Tablespace: -- CREATE INDEX contentlinks_content_idx ON contentlinks USING btree (con +tent_id); -- -- Name: fki_; Type: INDEX; Schema: public; Owner: oarj; Tablespace: -- CREATE INDEX fki_ ON name USING btree (lang_id); -- -- Name: fki_child; Type: INDEX; Schema: public; Owner: oarj; Tablespa +ce: -- CREATE INDEX fki_child ON parents USING btree (child_id); -- -- Name: fki_contents_repo; Type: INDEX; Schema: public; Owner: oarj; +Tablespace: -- CREATE INDEX fki_contents_repo ON contentlinks USING btree (repo_id); -- -- Name: fki_country; Type: INDEX; Schema: public; Owner: oarj; Tables +pace: -- CREATE INDEX fki_country ON repo USING btree (countrycode); -- -- Name: fki_grade; Type: INDEX; Schema: public; Owner: oarj; Tablespa +ce: -- CREATE INDEX fki_grade ON policy USING btree (grade_id); -- -- Name: fki_lang; Type: INDEX; Schema: public; Owner: oarj; Tablespac +e: -- CREATE INDEX fki_lang ON langlinks USING btree (lang_id); -- -- Name: fki_manager; Type: INDEX; Schema: public; Owner: oarj; Tables +pace: -- CREATE INDEX fki_manager ON managerlinks USING btree (manager_id); -- -- Name: fki_org; Type: INDEX; Schema: public; Owner: oarj; Tablespace +: -- CREATE INDEX fki_org ON netmaps USING btree (org_id); -- -- Name: fki_policy_repo; Type: INDEX; Schema: public; Owner: oarj; Ta +blespace: -- CREATE INDEX fki_policy_repo ON policy USING btree (repo_id); -- -- Name: fki_repo; Type: INDEX; Schema: public; Owner: oarj; Tablespac +e: -- CREATE INDEX fki_repo ON managerlinks USING btree (repo_id); -- -- Name: fki_repo_type; Type: INDEX; Schema: public; Owner: oarj; Tabl +espace: -- CREATE INDEX fki_repo_type ON typelinks USING btree (type_id); -- -- Name: fki_site_org; Type: INDEX; Schema: public; Owner: oarj; Table +space: -- CREATE INDEX fki_site_org ON sitelinks USING btree (org_id); -- -- Name: fki_source; Type: INDEX; Schema: public; Owner: oarj; Tablesp +ace: -- CREATE INDEX fki_source ON sourcelinks USING btree (source_id); -- -- Name: fki_sources; Type: INDEX; Schema: public; Owner: oarj; Tables +pace: -- CREATE INDEX fki_sources ON name USING btree (source_id); -- -- Name: fki_subject; Type: INDEX; Schema: public; Owner: oarj; Tables +pace: -- CREATE INDEX fki_subject ON subjectlinks USING btree (subject_code); -- -- Name: fki_sword_repo; Type: INDEX; Schema: public; Owner: oarj; Tab +lespace: -- CREATE INDEX fki_sword_repo ON sword USING btree (repo_id); -- -- Name: fki_type; Type: INDEX; Schema: public; Owner: oarj; Tablespac +e: -- CREATE INDEX fki_type ON policy USING btree (type_id); -- -- Name: fki_xml_source; Type: INDEX; Schema: public; Owner: oarj; Tab +lespace: -- CREATE INDEX fki_xml_source ON xml USING btree (source_id); -- -- Name: name_table_idx; Type: INDEX; Schema: public; Owner: oarj; Tab +lespace: -- CREATE INDEX name_table_idx ON name USING btree (table_id, tbl); -- -- Name: networks_dec_idx; Type: INDEX; Schema: public; Owner: oarj; T +ablespace: -- CREATE INDEX networks_dec_idx ON networks USING btree (dec_lower, dec_ +upper); -- -- Name: networks_hex_idx; Type: INDEX; Schema: public; Owner: oarj; T +ablespace: -- CREATE INDEX networks_hex_idx ON networks USING btree (hex_lower, hex_ +upper); -- -- Name: typelinks_type_repo_idx; Type: INDEX; Schema: public; Owner: +oarj; Tablespace: -- CREATE INDEX typelinks_type_repo_idx ON typelinks USING btree (type_id +, repo_id); -- -- Name: urls_table_idx; Type: INDEX; Schema: public; Owner: oarj; Tab +lespace: -- CREATE INDEX urls_table_idx ON urls USING btree (table_id, tbl); -- -- Name: child; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY parents ADD CONSTRAINT child FOREIGN KEY (child_id) REFERENCES org(id); -- -- Name: contents; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY contentlinks ADD CONSTRAINT contents FOREIGN KEY (content_id) REFERENCES conten +ttypes(id); -- -- Name: country; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY repo ADD CONSTRAINT country FOREIGN KEY (countrycode) REFERENCES countr +y(code); -- -- Name: grade; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY policy ADD CONSTRAINT grade FOREIGN KEY (grade_id) REFERENCES policygrade +(id); -- -- Name: lang; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY langlinks ADD CONSTRAINT lang FOREIGN KEY (lang_id) REFERENCES language(id); -- -- Name: language; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY name ADD CONSTRAINT language FOREIGN KEY (lang_id) REFERENCES language( +id); -- -- Name: manager; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY managerlinks ADD CONSTRAINT manager FOREIGN KEY (manager_id) REFERENCES manager +(id); -- -- Name: name; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY name2url ADD CONSTRAINT name FOREIGN KEY (name_id) REFERENCES name(id); -- -- Name: network; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY netmaps ADD CONSTRAINT network FOREIGN KEY (net_id) REFERENCES networks(id +); -- -- Name: opstatus; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY repo ADD CONSTRAINT opstatus FOREIGN KEY (opstatus) REFERENCES opstatus +(id); -- -- Name: org; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY netmaps ADD CONSTRAINT org FOREIGN KEY (org_id) REFERENCES org(id); -- -- Name: org; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY sitelinks ADD CONSTRAINT org FOREIGN KEY (org_id) REFERENCES org(id); -- -- Name: parent; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY parents ADD CONSTRAINT parent FOREIGN KEY (parent_id) REFERENCES org(id); -- -- Name: repo; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY langlinks ADD CONSTRAINT repo FOREIGN KEY (repo_id) REFERENCES repo(id); -- -- Name: repo; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY managerlinks ADD CONSTRAINT repo FOREIGN KEY (repo_id) REFERENCES repo(id); -- -- Name: repo; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY policy ADD CONSTRAINT repo FOREIGN KEY (repo_id) REFERENCES repo(id); -- -- Name: repo; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY typelinks ADD CONSTRAINT repo FOREIGN KEY (repo_id) REFERENCES repo(id); -- -- Name: repo; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY sitelinks ADD CONSTRAINT repo FOREIGN KEY (repo_id) REFERENCES repo(id); -- -- Name: repo; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY sourcelinks ADD CONSTRAINT repo FOREIGN KEY (repo_id) REFERENCES repo(id); -- -- Name: repo; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY subjectlinks ADD CONSTRAINT repo FOREIGN KEY (repo_id) REFERENCES repo(id); -- -- Name: repo; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY sword ADD CONSTRAINT repo FOREIGN KEY (repo_id) REFERENCES repo(id); -- -- Name: repo; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY contentlinks ADD CONSTRAINT repo FOREIGN KEY (repo_id) REFERENCES repo(id); -- -- Name: source; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY sourcelinks ADD CONSTRAINT source FOREIGN KEY (source_id) REFERENCES sources(i +d); -- -- Name: source; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY xml ADD CONSTRAINT source FOREIGN KEY (source_id) REFERENCES sources(i +d); -- -- Name: source; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY externalids ADD CONSTRAINT source FOREIGN KEY (source_id) REFERENCES sources(i +d); -- -- Name: sources; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY name ADD CONSTRAINT sources FOREIGN KEY (source_id) REFERENCES sources( +id); -- -- Name: subject; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY subjectlinks ADD CONSTRAINT subject FOREIGN KEY (subject_code) REFERENCES subje +cts(code); -- -- Name: type; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY policy ADD CONSTRAINT type FOREIGN KEY (type_id) REFERENCES policytype(id +); -- -- Name: type; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY typelinks ADD CONSTRAINT type FOREIGN KEY (type_id) REFERENCES repotype(id); -- -- Name: url; Type: FK CONSTRAINT; Schema: public; Owner: oarj -- ALTER TABLE ONLY name2url ADD CONSTRAINT url FOREIGN KEY (url_id) REFERENCES urls(id); -- -- Name: public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO PUBLIC; -- -- PostgreSQL database dump complete --
-- Ian Stuart
A man depriving some poor village, somewhere, of a first-class idiot.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^3: dbicdump not importing the full table (Postgres)
by Anonymous Monk on May 08, 2012 at 16:30 UTC |
In Section
Seekers of Perl Wisdom