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 <jmorgan3@xxxxxxx> 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 database
it doesn't work on it seems to hang on executing and when I cancel it I get
ERROR: canceling statement due to user request
CONTEXT: while inserting index tuple (6,13) in relation
"pg_type_typname_nsp_index"
SQL state: 57014
Hmm (pokes around) ... That error context message seems to only be
possible if we were blocked waiting for some other transaction.
I theorize that you have an uncommitted transaction someplace that
has created the same table name. Cancelling it would fix things.
regards, tom lane
