Re: How to get rid of notices for create table?

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/