Empty system tables
While looking for tables related to default ops I came across the following
tables that are not mentioned in the programmer docs system catalogues
section and are (in my database anyway) empty. Perhaps someone who is
closer to the catalogues can confirm that these are still used. If so,
perhaps we can update the docs to describe them.
pg_inheritproc
pg_listener
pg_relcheck
The following tables are used but are not listed in the docs with the
rest. How about a short description of each? Maybe even add some to
the diagram.
pg_attrdef
pg_description
pg_inherits
pg_ipl
pg_rewrite
pg_shadow
pg_statistic
pg_trigger
I'm still trying to figure out why I get that fmgr error when I use my
user defined type in a where clause. Can anyone point me to the tables
that I need to modify? Here is what I have modified so far.
pg_opclass
pg_amop
pg_amproc
pg_description
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.
darcy@druid.net ("D'Arcy" "J.M." Cain) writes:
perhaps we can update the docs to describe them.
pg_listener
pg_listener records which backends are actively listening for NOTIFY
conditions, and is used to transmit NOTIFY signals from one backend to
another. It will be empty if you do not have any active LISTEN
commands.
pg_shadow
Shadow user table, with the real passwords. (pg_user is actually
only a view of pg_shadow.)
pg_statistic
Per-column stats collected by VACUUM ANALYZE and used by the query
optimizer.
Dunno about the rest.
regards, tom lane
Import Notes
Reply to msg id not found: Yourmessageof21May1999090703-0400m10kp0r-0000bIC@druid.net | Resolved by subject fallback