Re: Two tables for the price of one?

Patrick Aland writes:

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

Both of these users probably have the same user id. See pg_shadow.usesysid
column. If this installation was ever subject of a backup/restore, then
this might explain things. If there are indeed duplicate user ids,
dropping and recreating gmguest should work.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/