Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DD3439FA2CB for ; Sat, 9 Dec 2006 17:24:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 56145-05 for ; Sat, 9 Dec 2006 17:23:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90504.mail.mud.yahoo.com (web90504.mail.mud.yahoo.com [216.252.100.171]) by postgresql.org (Postfix) with SMTP id ACF2A9F9F46 for ; Sat, 9 Dec 2006 17:24:01 -0400 (AST) Received: (qmail 78582 invoked by uid 60001); 9 Dec 2006 21:23:59 -0000 Message-ID: <20061209212359.78580.qmail@web90504.mail.mud.yahoo.com> DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=kKLITJr4tMJbNq4m7eBah8AABgKnEQ4/Kc4yyyq+tE9I9S+kQqd7AD0fHpEeDyZcEpGz6VJX8gFcs9CCBpk9RF0Am6ivvNC9ZmNpNWYu6lM5wa2J/R+45Rf7CxuZnrJxqKJsEJ6+z8eOIWDnERTy5Rokfx7S1lLp3IROMYgnVd0=; X-YMail-OSG: gvdriegVM1mPTXOoVsqd0NqGV6ZFWzrt6vYNyGsvDvqWL7cqCk0V4UaCDT.x5n432w27X0oCaS_NXdLfGpTdcjjwDE9GuKzyOpOREzCQVLkMK0W7PQBER7k0689CHLT3LeCnWFE1gUXld3jQYqsgTtq4aREhaAacu0g- Received: from [70.19.76.226] by web90504.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 13:23:59 PST Date: Sat, 9 Dec 2006 13:23:59 -0800 (PST) From: Philippe Salama Subject: pgexplorer cannot see data in tables To: PostgreSQL Admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-659725880-1165699439=:75763" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.446 tagged_above=0 required=5 tests=AWL, BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_10_20, HTML_MESSAGE, UPPERCASE_25_50 X-Spam-Level: ** X-Archive-Number: 200612/118 X-Sequence-Number: 23910 --0-659725880-1165699439=:75763 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-659725880-1165699439=:75763 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-659725880-1165699439=:75763--