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:[EMAIL PROTECTED]
Sent: Tuesday, June 15, 2004 10:04
AM
To: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Tuesday, June 15, 2004 6:56
AM
To: Tom Lane
Cc: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Tuesday, June 15, 2004 6:44
AM
To: Lee Wu
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] table not
shown
"Lee Wu" <[EMAIL PROTECTED]>
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
