Обсуждение: 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