From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Dale Seaburg <kg5lt(at)verizon(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Error creating a table |
Date: | 2018-01-02 22:40:17 |
Message-ID: | 721ea728-0583-9178-e49d-a54361b59416@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 01/02/2018 02:38 PM, Dale Seaburg wrote:
> le):
>
> 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.
I don't use PgAdmin but the error appears to be looking for
public_rowkey not public.rowkey. Further, it isn't a table you would be
looking for but an index.
Thanks,
JD
>
> Dale
>
>
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
***** Unless otherwise stated, opinions are my own. *****
From | Date | Subject | |
---|---|---|---|
Next Message | Ramamoorthi, Meenakshi | 2018-01-02 23:24:45 | Need information on the tools available to upload the shape files to the postgreSQL database |
Previous Message | Dale Seaburg | 2018-01-02 22:38:34 | Error creating a table |