Two tables for the price of one?

From: Patrick Aland <paland(at)stetson(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Two tables for the price of one?
Date: 2001-03-27 18:59:03
Message-ID: 20010327135901.L24273@stetson.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am seeing something kinda weird when I am creating tables (or viewing
existing ones):

<BEGIN SESSION>
bash$ createdb test
CREATE DATABASE
bash$ psql test
Welcome to psql, 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

test=# \dt
No relations found.
test=# CREATE TABLE mytable (
test(# id INT,
test(# stuff VARCHAR(10)
test(# );
CREATE
test=# \dt
List of relations
Name | Type | Owner
---------+-------+----------
mytable | table | gmguest
mytable | table | postgres
(2 rows)

test=#
</END SESSION>

As you can see when I create a table it appears it is either creating it
twice (not likely) or thinks that there are two instances of it. The
gmguest user is a guest user for another database however any database I
look at has another table for each table with this gmguest user as the
owner. I found this after seeing duplicate table names while trying to access a
database via odbc and MSAccess.

Anyone seen this before? I imagine somewhere I screwed up a system table
or something (don't remember doing it). I may just recompile and dump
and resoter the tables from scratch but I'd like to avoid it if
possible.

Thanks.

--
------------------------------------------------------------
Patrick Aland paland(at)stetson(dot)edu
Network Administrator Voice: 904.822.7217
Stetson University Fax: 904.822.7367
------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joel Dudley 2001-03-27 19:25:32 C functions, arguments, and ssh oh my!
Previous Message Christian Marschalek 2001-03-27 18:49:48 RE: Supertypes?