Re: How come column is locked?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How come column is locked?
Дата
Msg-id 579106.1688482067@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How come column is locked?  (Shaozhong SHI <shishaozhong@gmail.com>)
Список pgsql-sql
Shaozhong SHI <shishaozhong@gmail.com> writes:
> I used
> create table if not exists waternetwork1.walknetwortt3 (fid integer[]);
> in do statement.

Perhaps the table already existed, with some other column list?

> When I use
> insert into waternetwork1.walknetwortt3 select fid from a function
> it failed.

"It failed" is totally inadequate as a description of the problem.
Did you read the error message?  What does it say, exactly?

            regards, tom lane



В списке pgsql-sql по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: How come column is locked?
Следующее
От: Shaozhong SHI
Дата:
Сообщение: Working around insert into a_table from select things from a_function