On Fri, Dec 10, 2004 at 06:31:15PM -0300, Pablo Santiago Blum de Aguiar wrote:
> I'm getting boring notices when creating tables: [snip] > NOTICE: CREATE TABLE / PRIMARY KEY will create > implicit index "pk_cliente" for table "cliente" > NOTICE: CREATE TABLE / UNIQUE will create implicit > index "uk_email" for table "cliente" > CREATE TABLE > > Got a few questions: > > 1 - What those 2 notice messages mean? They're informational messages. PostgreSQL is telling you that it's creating indexes that you didn't explicitly request. > 2 - How can I get rid of them? See the "Error Reporting and Logging" section of the "Server Run-time Environment" chapter in the documentation. You can configure what message levels go to the server logs and to the client. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org