Re: Weird message when creating PK constraint named like table

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 exists
>
>> SQL state: 42P07
>
> Hmm. If I create them with the asterisks as part of the relation
> names, I see the asterisks in the messages:
>
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> "*T1*" for table "*T1*"
> ERROR: relation "*T1*" already exists
>

The * around the table name was added by the translation from the HTML to a plain text email.

If you display the HTML version of the original posting the name is written in bold, and I gues the plain text "converter" simply adds the asterisks as that is the usual convention for bold in plain text emails.

The original SQL is:

CREATE TABLE "T1"
(
"T1_ID" bigint NOT NULL,
CONSTRAINT "T1" PRIMARY KEY ("T1_ID" )
);