Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8BC1E9F9ED7 for ; Sat, 23 Dec 2006 02:48:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 82028-08 for ; Sat, 23 Dec 2006 02:48:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 5E65E9F9F47 for ; Sat, 23 Dec 2006 02:48:14 -0400 (AST) Received: from [192.168.42.125] (natpool.bovine.net [67.100.216.14]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id 80D7F5643D; Sat, 23 Dec 2006 06:48:13 +0000 (UTC) In-Reply-To: <20061209212359.78580.qmail@web90504.mail.mud.yahoo.com> References: <20061209212359.78580.qmail@web90504.mail.mud.yahoo.com> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <41E8D220-192A-45AF-B3DC-098AC487DF75@decibel.org> Cc: PostgreSQL Admin Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: pgexplorer cannot see data in tables Date: Fri, 22 Dec 2006 17:55:11 -0500 To: Philippe Salama X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/301 X-Sequence-Number: 24093 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 jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)