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" )
);
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
