| 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: | Whole Thread | Raw Message | 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
------------------------------------------------------------
| 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? |