So did the script with those inserts report any errors?
On Dec 9, 2006, at 4:23 PM, Philippe Salama wrote:
and yet, the script I ran clearly has inserts of data to the
tables. And there was no indication that something failed when I
ran the script
Here is an excerpt from the script file
ALTER TABLE format.statuscodes OWNER TO postgres;
SET search_path = define, pg_catalog;
--
-- Data for Name: absenteeism; Type: TABLE DATA; Schema: define;
Owner: postgres
--
INSERT INTO absenteeism VALUES (1, 1, '2006-06-30', 'DA', 1);
--
-- Data for Name: badges; Type: TABLE DATA; Schema: define; Owner:
postgres
--
INSERT INTO badges VALUES (1, 1, '2006-06-30', 'A');
INSERT INTO badges VALUES (2, 1, '2006-06-30', 'I');
--
-- Data for Name: departments; Type: TABLE DATA; Schema: define;
Owner: postgres
--
INSERT INTO departments VALUES (1, 'Piping');
INSERT INTO departments VALUES (2, 'Electrical');
INSERT INTO departments VALUES (3, 'Instrumentation');
INSERT INTO departments VALUES (4, 'Process');
INSERT INTO departments VALUES (5, 'Mechanical');
--
-- Data for Name: doctors; Type: TABLE DATA; Schema: define; Owner:
postgres
--
INSERT INTO doctors VALUES ('Baker');
INSERT INTO doctors VALUES ('Dow');
INSERT INTO doctors VALUES ('DOW');
Need a quick answer? Get one in minutes from people who know. Ask
your question on Yahoo! Answers.
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
