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
------------------------------------------------------------
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? |