A. Kretschmer wrote:
In response to Bryce Nesbitt :
Hmm, no. I still get the NOTICE. How can I create the primary key
without triggering a NOTICE?
Sure, set client_min_messages='...'
test=*# create table bla(id int primary key);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "bla_pkey" for table
"bla"
CREATE TABLE
test=*# rollback;
ROLLBACK
test=# set client_min_messages='warning';
SET
test=*# create table bla(id int primary key);
CREATE TABLE
test=*#
Andreas
Funny thing is I'm using set client_min_message in my own scripts!
Also was assuming OP was in a scripting/temp-table mode and that the
notion of explicit primary key (vs. simply stating the index) isn't of
great value in that realm I don't think.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
