H
H
Hello World2019-02-09 16:44:04
PostgreSQL
Hello World, 2019-02-09 16:44:04

Why can't I create a table with that name?

I want to create a table called id488796515 but it doesn't work.
And if you create a table called id488796516, then everything is fine. Why?

vk_conversations=# CREATE TABLE id488796515 (msg_id INTEGER NOT NULL,from_id INTEGER NOT NULL,attachments json[] NOT NULL,fwd_messages json[] NOT NULL);
^CCancel request sent
ОШИБКА:  выполнение оператора отменено по запросу пользователя
КОНТЕКСТ:  при добавлении кортежа индекса (9,44) в отношении "pg_type_typname_nsp_index"
vk_conversations=# CREATE TABLE id488796516 (msg_id INTEGER NOT NULL,from_id INTEGER NOT NULL,attachments json[] NOT NULL,fwd_messages json[] NOT NULL);
CREATE TABLE
vk_conversations=# \d
             Список отношений
 Схема  |     Имя     |   Тип   | Владелец 
--------+-------------+---------+----------
 public | id488796516 | таблица | postgres
(1 строка)

vk_conversations=#

Answer the question

In order to leave comments, you need to log in

2 answer(s)
H
Hello World, 2019-02-09
@hello-world00

Sorry for the really stupid question. The mistake was made out of stupidity. (I forgot to close the connection in python)

S
Sergey Gornostaev, 2019-02-09
@sergey-gornostaev

First, a table is not a database. Secondly, judging by the message, you pressed Ctrl+C, so the table was not created.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question