More sepgsql weirdness
От | Dave Page |
---|---|
Тема | More sepgsql weirdness |
Дата | |
Msg-id | CA+OCxozBBWGXdi_dY8G5bZmNR2y7G5HRyAWWYg=VpB-=8WX2DA@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: More sepgsql weirdness
|
Список | pgsql-hackers |
mls=# SELECT current_user;
current_user
--------------
postgres
(1 row)
mls=# SHOW search_path;
search_path
-----------------
"$user", public
(1 row)
mls=# \dn+ public
List of schemas
Name | Owner | Access privileges | Description
--------+----------+----------------------+------------------------
public | postgres | postgres=UC/postgres+| standard public schema
| | =UC/postgres |
(1 row)
mls=# CREATE TABLE tb_users(uid int primary key, name text, mail text, address text, salt text, phash text);
ERROR: no schema has been selected to create in
LINE 1: CREATE TABLE tb_users(uid int primary key, name text, mail t...
^
mls=# CREATE TABLE public.tb_users(uid int primary key, name text, mail text, address text, salt text, phash text);
CREATE TABLE
mls=# drop table tb_users;
ERROR: table "tb_users" does not exist
mls=# drop table public.tb_users;
DROP TABLE
В списке pgsql-hackers по дате отправления: