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/