Query in SQL statement
| От | R, Rajesh (STSD) |
|---|---|
| Тема | Query in SQL statement |
| Дата | |
| Msg-id | 5CBFB210D9870F40B9E5A0FBD31F3A770283AC48@bgeexc01.asiapacific.cpqcorp.net обсуждение исходный текст |
| Ответы |
Re: Query in SQL statement
Re: [PERFORM] Query in SQL statement |
| Список | pgsql-hackers |
Am trying to port a mysql statement to postgres.
Please help me in finding the error in this,
CREATE SEQUENCE ai_id;
CREATE TABLE badusers (
id int DEFAULT nextval('ai_id') NOT NULL,
UserName varchar(30),
Date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
Reason varchar(200),
Admin varchar(30) DEFAULT '-',
PRIMARY KEY (id),
KEY UserName (UserName),
KEY Date (Date)
);
Am always getting foll. Errors,
ERROR: relation "ai_id" already exists
ERROR: syntax error at or near "(" at character 240
Thanks,
Rajesh R
В списке pgsql-hackers по дате отправления: