From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Second question on schemas and INDEX(es) ... |
Date: | 2003-10-15 20:20:56 |
Message-ID: | 1066249256.2070.1.camel@camel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, 2003-10-15 at 16:00, Marc G. Fournier wrote:
>
> Okay, after feeling stupid about the last one (altho I hadn't thought to
> read the CREATE INDEX page, only the CREATE SCHEMA one), I really hate to
> ask this one ... but ... is this documented somewhere also:
>
> CREATE SCHEMA company_00244
> CREATE TABLE traffic ( ip_id int4, port int4, bytes bigint, runtime timestamp )
> CREATE INDEX traffic_dist ON traffic USING BTREE ( ip_id, port )
> CREATE INDEX traffic_time ON traffic USING btree ( hour_trunc(runtime));
>
> ERROR: parser: parse error at or near "INDEX" at character 122
>
> or, is there an obvious error that I'm just not seeing?
>
> The CREATE SCHEMA page shows CREATE TABLE and CREATE VIEW, so should I
> consider CREATE INDEX no supported since it wasn't part of the example?
>
If I'm right your having a heck of a bad day, but I believe the problem
is you have no ; after each of your sql statements...
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2003-10-15 20:21:26 | Re: Second question on schemas and INDEX(es) ... |
Previous Message | Marc G. Fournier | 2003-10-15 20:00:54 | Second question on schemas and INDEX(es) ... |