Re: How come column is locked? - Mailing list pgsql-sql

From Tom Lane
Subject Re: How come column is locked?
Date
Msg-id 579106.1688482067@sss.pgh.pa.us
Whole thread Raw
In response to How come column is locked?  (Shaozhong SHI <shishaozhong@gmail.com>)
List 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 by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: How come column is locked?
Next
From: Shaozhong SHI
Date:
Subject: Working around insert into a_table from select things from a_function