Thread: AIX Port Strangness
Bruce, I thought I saw a blurb about the NAMELEN changing to 31 plus '\0'. Is there any thing going on there.
*************************************************************************
CREATE TABLE foo (
bar int
);
CREATE
select oid, * from pg_class where relname like '%foo%';
oid|relname|reltype|relowner|relam|relpages|reltuples|relhasindex|relisshared|relkind|relnatts|relchecks|reltriggers|relhasrules|r
elacl
-----+-------+-------+--------+-----+--------+---------+-----------+-----------+-------+--------+---------+-----------+-----------+------
19040|foo | 0| 6095| 0| 0| 0|f |f |r | 1| 0| 0|f |
(1 row)
CREATE INDEX foo_idx ON foo USING btree(bar);
CREATE
select oid, * from pg_class where relname like '%foo%';
oid|relname|reltype|relowner|relam|relpages|reltuples|relhasindex|relisshared|relkind|relnatts|relchecks|reltriggers|relhasrules|relacl
-----+-------+-------+--------+-----+--------+---------+-----------+-----------+-------+--------+---------+-----------+-----------+------
19040|foo | 0| 6095| 0| 0| 0|t |f |r | 1| 0| 0|f |
19049|foo_idx| 0| 6095| 403| 2| 2048|f |f |i | 1| 0| 0|f |
(2 rows)
select oid, * from pg_class where relname like 'foo%';
oid|relname|reltype|relowner|relam|relpages|reltuples|relhasindex|relisshared|relkind|relnatts|relchecks|reltriggers|relhasrules|relacl
---+-------+-------+--------+-----+--------+---------+-----------+-----------+-------+--------+---------+-----------+-----------+------
(0 rows)
\d
Database = daveh
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
| daveh | foo | table |
| daveh | foo_idx | index |
+------------------+----------------------------------+----------+
\d foo
Couldn't find table foo!