Kevin Grittner, 11.01.2012 21:16:
When I do this
CREATE TABLE "*T1*"
(
"T1_ID" bigint NOT NULL,
CONSTRAINT "*T1*" PRIMARY KEY ("T1_ID" )
);
I get the following message:
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"T1" for table "T1"
ERROR: relation "T1" already exist
Hello, r.
You wrote:
rd> When I do this
rd> CREATE TABLE "T1"
rd> (
rd> "T1_ID" bigint NOT NULL,
rd> CONSTRAINT "T1" PRIMARY KEY ("T1_ID" )
rd> );
rd> I get the following message:
rd> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "T1" for
table "T1"
rd> ERROR: relation "
r d writes:
> The SQLSTATE 42P07 is described in the manual as only as "table undefined",
> and it is not clear if the intent is to allow or
> disallow the creation of a constraint called the same as the table in
> Postgresql.
Where do you see that? In Appendix A that code is listed as
"duplicat
r d wrote:
> When I do this
>
> CREATE TABLE "*T1*"
> (
> "T1_ID" bigint NOT NULL,
> CONSTRAINT "*T1*" PRIMARY KEY ("T1_ID" )
> );
>
>
> I get the following message:
>
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "T1" for table "T1"
> ERROR: relation "T1" already e
When I do this
CREATE TABLE "*T1*"
> (
> "T1_ID" bigint NOT NULL,
> CONSTRAINT "*T1*" PRIMARY KEY ("T1_ID" )
> );
I get the following message:
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "T1" for
> table "T1"
> ERROR: relation "T1" already exists
> ** Error *