Re: Can't CREATE INDEX on a schema?

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Can't CREATE INDEX on a schema?
Date: 2003-10-15 18:32:01
Message-ID: 3F8D92A1.5010003@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Marc G. Fournier wrote:

>or am I doing it wrong?
>
>ams=# create index company_00001.traffic_ip on company_00001.traffic using btree ( ip_id ) ;
>ERROR: parser: parse error at or near "." at character 27
>
>
>
/Docs on "create index" state:

index_name

/
The name of the index to be created. No schema name can be
included here; the index is always created in the same schema as its
parent table.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-10-15 19:35:43 Re: postgres --help-config
Previous Message Neil Conway 2003-10-15 18:28:15 Re: Can't CREATE INDEX on a schema?