@@ -213,10 +213,11 @@ x|y |z
213213(2 rows)
214214
215215QUERY: CREATE TABLE PRIMARY_TBL (i int PRIMARY KEY, t text);
216+ NOTICE:CREATE TABLE/PRIMARY KEY will create implicit index primary_tbl_pkey for table primary_tbl
216217QUERY: INSERT INTO PRIMARY_TBL VALUES (1, 'one');
217218QUERY: INSERT INTO PRIMARY_TBL VALUES (2, 'two');
218219QUERY: INSERT INTO PRIMARY_TBL VALUES (1, 'three');
219- WARN:Cannot insert a duplicate key into a unique index.
220+ WARN:Cannot insert a duplicate key into a unique index
220221QUERY: INSERT INTO PRIMARY_TBL VALUES (4, 'three');
221222QUERY: INSERT INTO PRIMARY_TBL VALUES (5, 'one');
222223QUERY: INSERT INTO PRIMARY_TBL (t) VALUES ('six');
@@ -233,6 +234,7 @@ four|i|t
233234QUERY: DROP TABLE PRIMARY_TBL;
234235QUERY: CREATE TABLE PRIMARY_TBL (i int, t text,
235236PRIMARY KEY(i,t));
237+ NOTICE:CREATE TABLE/PRIMARY KEY will create implicit index primary_tbl_pkey for table primary_tbl
236238QUERY: INSERT INTO PRIMARY_TBL VALUES (1, 'one');
237239QUERY: INSERT INTO PRIMARY_TBL VALUES (2, 'two');
238240QUERY: INSERT INTO PRIMARY_TBL VALUES (1, 'three');
@@ -252,10 +254,11 @@ three|i|t
252254
253255QUERY: DROP TABLE PRIMARY_TBL;
254256QUERY: CREATE TABLE UNIQUE_TBL (i int UNIQUE, t text);
257+ NOTICE:CREATE TABLE/UNIQUE will create implicit index unique_tbl_i_key for table unique_tbl
255258QUERY: INSERT INTO UNIQUE_TBL VALUES (1, 'one');
256259QUERY: INSERT INTO UNIQUE_TBL VALUES (2, 'two');
257260QUERY: INSERT INTO UNIQUE_TBL VALUES (1, 'three');
258- WARN:Cannot insert a duplicate key into a unique index.
261+ WARN:Cannot insert a duplicate key into a unique index
259262QUERY: INSERT INTO UNIQUE_TBL VALUES (4, 'four');
260263QUERY: INSERT INTO UNIQUE_TBL VALUES (5, 'one');
261264QUERY: INSERT INTO UNIQUE_TBL (t) VALUES ('six');
@@ -274,11 +277,12 @@ five|i|t
274277QUERY: DROP TABLE UNIQUE_TBL;
275278QUERY: CREATE TABLE UNIQUE_TBL (i int, t text,
276279UNIQUE(i,t));
280+ NOTICE:CREATE TABLE/UNIQUE will create implicit index unique_tbl_i_key for table unique_tbl
277281QUERY: INSERT INTO UNIQUE_TBL VALUES (1, 'one');
278282QUERY: INSERT INTO UNIQUE_TBL VALUES (2, 'two');
279283QUERY: INSERT INTO UNIQUE_TBL VALUES (1, 'three');
280284QUERY: INSERT INTO UNIQUE_TBL VALUES (1, 'one');
281- WARN:Cannot insert a duplicate key into a unique index.
285+ WARN:Cannot insert a duplicate key into a unique index
282286QUERY: INSERT INTO UNIQUE_TBL VALUES (5, 'one');
283287QUERY: INSERT INTO UNIQUE_TBL (t) VALUES ('six');
284288QUERY: SELECT '' AS five, * FROM UNIQUE_TBL;
