Обсуждение: BUG #15870: You can't see the table after executing the table-building statement with \i

Поиск
Список
Период
Сортировка

BUG #15870: You can't see the table after executing the table-building statement with \i

От
PG Bug reporting form
Дата:
The following bug has been logged on the website:

Bug reference:      15870
Logged by:          强 魏
Email address:      1726002692@qq.com
PostgreSQL version: 12beta2
Operating system:   CentOS Linux release 7.6.1810 (Core)  GCC-4.8.5
Description:

postgres@127.0.0.1:5432[cmis_to_mysql]#\i
/home/postgres/aa/cmis_to_mysql.sql
SET
Time: 0.550 ms
SET
Time: 0.573 ms
SET
Time: 0.910 ms
SET
Time: 1.353 ms
SET
Time: 1.049 ms
+------------+
| set_config |
+------------+
|            |
+------------+
(1 row)

Time: 2.336 ms
SET
Time: 0.298 ms
SET
Time: 0.256 ms
SET
Time: 0.203 ms
SET
Time: 0.273 ms
SET
Time: 0.184 ms
SET
Time: 0.387 ms
CREATE TABLE
Time: 56.455 ms
ALTER TABLE
Time: 3.026 ms
COMMENT
Time: 8.306 ms
COMMENT
Time: 2.670 ms
COMMENT
Time: 1.989 ms
COMMENT
Time: 3.834 ms
COMMENT
Time: 2.543 ms
COPY 12
Time: 4.449 ms
CREATE INDEX
Time: 8.782 ms
CREATE INDEX
Time: 4.601 ms
postgres@127.0.0.1:5432[cmis_to_mysql]#\d
Did not find any relations.
postgres@127.0.0.1:5432[cmis_to_mysql]#\c cmis_to_mysql
You are now connected to database "cmis_to_mysql" as user "postgres".
postgres@127.0.0.1:5432[cmis_to_mysql]#\d
              List of relations
+--------+---------------+-------+----------+
| Schema |     Name      | Type  |  Owner   |
+--------+---------------+-------+----------+
| public | cmis_to_mysql | table | postgres |
+--------+---------------+-------+----------+
(1 row)


Re: BUG #15870: You can't see the table after executing the table-building statement with \i

От
Sergei Kornilov
Дата:
Hello

Seems you tried import something from pg_dump result. Please check query text with set_config response in yours log. I
thinkthis is:
 

SELECT pg_catalog.set_config('search_path', '', false);

If so all works as expected and not related to \i command.

regards, Sergei