X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9A779D1B7D6 for ; Tue, 15 Jun 2004 16:02:56 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45353-06 for ; Tue, 15 Jun 2004 19:02:55 +0000 (GMT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 6D5BDD1B54D for ; Tue, 15 Jun 2004 16:02:52 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i5FHV59U009506; Tue, 15 Jun 2004 13:31:06 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i5FJ2MN01735; Tue, 15 Jun 2004 15:02:22 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id LP85LA9W; Tue, 15 Jun 2004 15:02:20 -0400 Subject: Re: table not shown From: Robert Treat To: Lee Wu Cc: Duane Lee - EGOVX , Tom Lane , pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 15 Jun 2004 15:02:21 -0400 Message-Id: <1087326141.9249.1205.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/179 X-Sequence-Number: 13839 do a vacuum full on template1 and see if it reappears. Robert Treat On Tue, 2004-06-15 at 13:10, Lee Wu wrote: > Hi Duane, > > > > It seems it is not: > > > > mxl=# show search_path; > > search_path > > -------------- > > $user,public > > (1 row) > > mxl=# select current_schema(), current_user; > > current_schema | current_user > > ----------------+-------------- > > public | postgres > > (1 row) > > > > mxl=# select * from pg_class where relname = 'mxl_quar_process'; select > * from mxl_quar_process limit 1; > > relname | relnamespace | reltype | relowner | relam | relfilenode | > relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | > relisshared | relkind | relnatts | relchecks | reltriggers | relukeys | > relfkeys | relrefs | relhasoids | relhaspkey | relhasrules | > relhassubclass | relacl > > ---------+--------------+---------+----------+-------+-------------+---- > ------+-----------+---------------+---------------+-------------+------- > ------+---------+----------+-----------+-------------+----------+------- > ---+---------+------------+------------+-------------+----------------+- > ------- > > (0 rows) > > > > quar_id | customer_id | domain_id | user_id | host_id | > path | module | > attempts | state | created > > ------------+-------------+-----------+----------+---------+------------ > ------------------------------------------------------------------------ > -----------------------------+---------+----------+-------+------------- > ------------------ > > 2012787039 | 8022315 | 8022316 | 20018272 | 7953027 | > /mxl/quarantine/p01m183.mxlogic.net/hmausa.com/20031212/b6/b6e39df3.7682 > .021.p01m183-8022316-20018272-0.zip.enc | keyword | 0 | 1 | > 2004-01-09 23:49:44.056513-07 > > (1 row) > > > > Also, when I do: > > pg_dump -U postgres -f 615.dump > > Password: > > pg_dump: invalid adnum value 5 for table mxl_user_wbl > > > > mxl=# \d mxl_user_wbl > > Table "public.mxl_user_wbl" > > Column | Type | Modifiers > > ---------+--------------------------+----------------------------------- > ----------------- > > user_id | integer | not null > > sender | character varying(128) | not null > > action | integer | > > created | timestamp with time zone | default > ('now'::text)::timestamp(6) with time zone > > Indexes: mxl_user_wbl_pkey primary key btree (user_wbl_id), > > mxl_user_wbl_uid_action_idx btree (user_id, "action") > > Foreign Key constraints: mxl_user_wbl_uid_fkey FOREIGN KEY (user_id) > REFERENCES mxl_user(user_id) ON UPDATE NO ACTION ON DELETE CASCADE > > Triggers: mxl_user_wbl_u_trg > > > > I know mxl_user_wbl is not same as mxl_quar_process, but this pg_dump > error causes our > > production database backup failed! > > > > Please help! > > > > Thank you! > > > > -----Original Message----- > From: Duane Lee - EGOVX [mailto:DLee@mail.maricopa.gov] > Sent: Tuesday, June 15, 2004 9:22 AM > To: Lee Wu; Tom Lane > Cc: pgsql-admin@postgresql.org > Subject: RE: [ADMIN] table not shown > > > > Could this be a schema issue? > > -----Original Message----- > From: Lee Wu [ mailto:Lwu@mxlogic.com ] > Sent: Tuesday, June 15, 2004 6:56 AM > To: Tom Lane > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] table not shown > > > > Here is screen shot: > > psql > Password: > Welcome to psql 7.3.2, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help on internal slash commands > \g or terminate with semicolon to execute query > \q to quit > > mxl=# \d mxl_quar_process > Did not find any relation named "mxl_quar_process". > mxl=# \dt mxl_quar_process > No matching relations found. > mxl=# select * from pg_class where relname = 'mxl_quar_process'; > relname | relnamespace | reltype | relowner | relam | relfilenode | > relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | > relisshared | relkind | relnatts | relchecks | reltriggers | relukeys | > relfkeys | relrefs | relhasoids | relhaspkey | relhasrules | > relhassubclass | relacl > ---------+--------------+---------+----------+-------+-------------+---- > > ------+-----------+---------------+---------------+-------------+------- > > ------+---------+----------+-----------+-------------+----------+------- > > ---+---------+------------+------------+-------------+----------------+- > > ------- > (0 rows) > > mxl=# select * from mxl_quar_process limit 1; > quar_id | customer_id | domain_id | user_id | host_id | > path | module | > attempts | state | created > ------------+-------------+-----------+----------+---------+------------ > > ------------------------------------------------------------------------ > > -----------------------------+---------+----------+-------+------------- > > ------------------ > 2012787039 | 8022315 | 8022316 | 20018272 | 7953027 | > /mxl/quarantine/p01m183.mxlogic.net/hmausa.com/20031212/b6/b6e39df3.7682 > > .021.p01m183-8022316-20018272-0.zip.enc | keyword | 0 | 1 | > 2004-01-09 23:49:44.056513-07 > (1 row) > > mxl=# > > -----Original Message----- > From: Tom Lane [ mailto:tgl@sss.pgh.pa.us ] > Sent: Tuesday, June 15, 2004 6:44 AM > To: Lee Wu > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] table not shown > > "Lee Wu" writes: > > We have table is database which cannot be displayed by > > either \d, or \dt or pg_class. > > > But we can select, DML on it. > > You could not possibly be selecting from it if it's not in pg_class. > I expect this is pilot error on your part, but there's not enough info > here to guess just what. Could you show exact examples of a successful > select, the other inquiries you tried, and exactly what you got from > them? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL