From: | "R, Rajesh (STSD)" <rajesh(dot)r2(at)hp(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org> |
Subject: | Query in SQL statement |
Date: | 2005-09-29 13:05:14 |
Message-ID: | 5CBFB210D9870F40B9E5A0FBD31F3A770283AC48@bgeexc01.asiapacific.cpqcorp.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Fabien COELHO | 2005-09-29 13:24:15 | Re: Install pg_regress script to support PGXS? |
Previous Message | Hannu Krosing | 2005-09-29 12:46:30 | Re: Constraint exclusion, some questions |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2005-09-29 13:22:03 | Re: Comparative performance |
Previous Message | Joe | 2005-09-29 12:44:16 | Re: Comparative performance |