Re: table not shown - Mailing list pgsql-admin

Thank you.

But this is not my case:

mxl=# select relname from pg_class where lower(relname) = 'mxl_quar_process'; select * from mxl_quar_process limit 1;

 relname

---------

(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)

mxl=#

-----Original Message-----
From: banghe [mailto:banghe@baileylink.net]
Sent: Tuesday, June 15, 2004 10:04 AM
To: pgsql-admin@postgresql.org
Cc: Duane Lee - EGOVX; Lee Wu; Tom Lane
Subject: Re: [ADMIN] table not shown

I am using the lower version of postgres. I had some similar experience with my lower version of postgres (v6.5) and have solved the issures.
However, I am not sure if the method I used could work, so just tips for you to try.

You may check the script of your ori. definition of the table, pay attention to the case of  table name spelling, and use the quotations.
e.g. your table name was written in your definition script as "Mxl_Quar_Process",

use sql commmand:
sql>  \d "Mxl_Quar_Process";

Sometimes the reserved words may also cause such problems.  In this case, I doubt the word "process" may be one of  reserved words, so using  quotations may help.

Bnaghe

Duane Lee - EGOVX wrote:

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" <Lwu@mxlogic.com> 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