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