From: | Robert Starr <rob(at)surrenderdorothy(dot)com(dot)au> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | restoring a backup and maintaining dependencies? |
Date: | 2007-09-13 04:56:06 |
Message-ID: | 46E8C2E6.204@surrenderdorothy.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi again :)
I have saved out these commands:
CREATE TABLE group_items
(
id serial NOT NULL,
group_id integer,
group_type text,
item_id integer,
visible integer,
CONSTRAINT "group_items_PK" PRIMARY KEY (id)
)
WITHOUT OIDS;
ALTER TABLE group_items OWNER TO postgres;
CREATE SEQUENCE group_items_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
ALTER TABLE group_items_id_seq OWNER TO postgres;
If I restore them in pgadmin will they become dependent on each other in
the same way as if I created the table in pgadmin? Or will they just
become separate entities without any form of link? If that IS the case,
how can I link them with SQL code, rather than pgadmin?
Advice appreciated lots, I have a lot to learn here :|
rob
From | Date | Subject | |
---|---|---|---|
Next Message | Laurent Yaish | 2007-09-13 05:48:23 | Re: ERROR: duplicate key violates unique constraint "client_alerts_PK" |
Previous Message | Robert Starr | 2007-09-13 03:52:54 | ERROR: duplicate key violates unique constraint "client_alerts_PK" |