Re: CREATE TABLE AS SELECT hangs

2018-10-02 Thread derek
Tom. Thanks so much for your response. Your theory appears to have been correct, and it is working like a champ now. Best, Derek On 10/1/2018 4:29 PM, Tom Lane wrote: derek writes: I am trying to populate/create a database with CREATE TABLE AS SELECT like so: CREATE TABLE test_table

Re: CREATE TABLE AS SELECT hangs

2018-10-01 Thread Tom Lane
derek writes: > I am trying to populate/create a database with CREATE TABLE AS SELECT > like so: > CREATE TABLE test_table AS > SELECT row_number() over() as gid, cells.geom > FROM test_geom_function(1,2,3) AS cells; > This works on one database instance, but not on another. On the