Two tables for the price of one?
От | Patrick Aland |
---|---|
Тема | Two tables for the price of one? |
Дата | |
Msg-id | 20010327135901.L24273@stetson.edu обсуждение исходный текст |
Ответы |
Re: Two tables for the price of one?
|
Список | 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@stetson.edu Network Administrator Voice: 904.822.7217 Stetson University Fax: 904.822.7367 ------------------------------------------------------------
В списке pgsql-general по дате отправления: