# code like this causes the notice you listed
CREATE TABLE foo (
  id char(32) unique
);

# if you don't want the notice, don't let it create
# implicit indexes, create them yourself explicitly
CREATE TABLE foo (
  id char(32)
);
ALTER TABLE ONLY foo
    ADD CONSTRAINT foo_id_key UNIQUE (id);