Problem with the constraints test and PRIMARY KEY on UnixWare 7.

In the constraints test, a table (primary_tbl) is defined with a primary key.
The table is created, shows up in the list of table using the \dt command, but
does not exist if you use the \d command, or any SQL statement referencing the
table. Here is the output from the \dt and \d command.

regression=>\dt

Database = regression
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
[...]
| postgres | path_tbl | table |
| postgres | person | table |
| postgres | point_tbl | table |
| postgres | polygon_tbl | table |
| postgres | primary_tbl | table |
| postgres | real_city | table |
| postgres | reltime_tbl | table |
| postgres | road | table |
[...]
+------------------+----------------------------------+----------+
regression=> \d primary_tbl
Couldn't find table primary_tbl!
regression=> \di

Database = regression
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
| postgres | primary_tbl_pkey | index |
| postgres | unique_tbl_i_key | index |
+------------------+----------------------------------+----------+
regression=> \d primary_tbl_pkey

Table = primary_tbl_pkey
+----------------------------------+----------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------+-------+
| i | int4 | 4 |
+----------------------------------+----------------------------+-------+
regression=>

The problem seems to be restrict to the use of PRIMARY KEY, since unique_table
works fine.

And here is the relavent portions from test output.

QUERY: CREATE TABLE PRIMARY_TBL (i int PRIMARY KEY, t text);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
primary_tbl_pkey for table primary_tbl
QUERY: INSERT INTO PRIMARY_TBL VALUES (1, 'one');
ERROR: primary_tbl: Table does not exist.
QUERY: INSERT INTO PRIMARY_TBL VALUES (2, 'two');
ERROR: primary_tbl: Table does not exist.
[...]
QUERY: SELECT '' AS four, * FROM PRIMARY_TBL;
ERROR: primary_tbl: Table does not exist.
QUERY: DROP TABLE PRIMARY_TBL;
ERROR: Relation primary_tbl Does Not Exist!
QUERY: CREATE TABLE PRIMARY_TBL (i int, t text, PRIMARY KEY(i,t));
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
primary_tbl_pkey for table primary_tbl
ERROR: cannot create primary_tbl
QUERY: INSERT INTO PRIMARY_TBL VALUES (1, 'one');
ERROR: primary_tbl: Table does not exist.
QUERY: INSERT INTO PRIMARY_TBL VALUES (2, 'two');
ERROR: primary_tbl: Table does not exist.
[...]
QUERY: SELECT '' AS three, * FROM PRIMARY_TBL;
ERROR: primary_tbl: Table does not exist.
QUERY: DROP TABLE PRIMARY_TBL;
ERROR: Relation primary_tbl Does Not Exist!

Any help would be appreciated.
Thanks.
--
____ | Billy G. Allie | Domain....: Bill(dot)Allie(at)mug(dot)org
| /| | 7436 Hartwell | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie(at)email(dot)msn(dot)com
|/ |LLIE | (313) 582-1540 |