How to get rid of notices for create table?
От | Pablo Santiago Blum de Aguiar |
---|---|
Тема | How to get rid of notices for create table? |
Дата | |
Msg-id | 20041210213115.15087.qmail@web52208.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: How to get rid of notices for create table?
|
Список | pgsql-general |
Hi, I did a search for this issue but don't seem to find anything reasonably satisfactory. I'm getting boring notices when creating tables: test=# CREATE TABLE cliente ( test(# id INTEGER NOT NULL, test(# id_indica INTEGER NULL, test(# email VARCHAR(40) NULL, test(# contato VARCHAR(40) NULL, test(# data DATE DEFAULT NOW(), test(# log VARCHAR(40) NOT NULL, test(# num VARCHAR(16) NOT NULL, test(# comp VARCHAR(16) NULL, test(# bairro VARCHAR(40) NOT NULL, test(# cep CHAR(8) NOT NULL, test(# cidade VARCHAR(40) NOT NULL, test(# estado CHAR(2) NOT NULL, test(# refend VARCHAR(256) NULL, test(# CONSTRAINT pk_cliente PRIMARY KEY (id), test(# CONSTRAINT uk_email UNIQUE (email), test(# CONSTRAINT ck_indica CHECK (id != id_indica) test(# ); 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? 2 - How can I get rid of them? Regards, Scorphus. ===== -- .''`. Pablo Aguiar <pabloaguiar at yahoo.com> : :' : Proud Debian GNU/Linux Admin and User `. `'` GNU/Linux User #346447 - PC #238975 `- Debian, when you have better things to do than fix a system. _______________________________________________________ Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra uma conta agora! http://br.info.mail.yahoo.com/
В списке pgsql-general по дате отправления: