Error creating a table

From: Dale Seaburg <kg5lt(at)verizon(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Error creating a table
Date: 2018-01-02 22:38:34
Message-ID: 1f824a99-4247-ea80-1c28-7b9bcf7569b6@verizon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am in pgAdmin, attempting to create a table in an existing database.
This table is normally created and deleted by software I have written (C#).
I get this kind of error when executing the CREATE TABLE script (which
is a copy of similarly named table):

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"public_rowkey" for table "ABSTRACT-SERVER_runsheet"

ERROR:  relation "public_rowkey" already exists

********** Error **********

ERROR: relation "public_rowkey" already exists
SQL state: 42P07

I have looked for rowkey in the "public" schema, but find nothing.
What can be the problem?  What might I be doing wrong?  I'm not sure
what to do.

Dale

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2018-01-02 22:40:17 Re: Error creating a table
Previous Message Martin Moore 2018-01-02 21:28:39 Re: Slow system due to ReorderBufferGetTupleBuf?