Query in SQL statement

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

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-performance by date

  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