Re: Can't CREATE INDEX on a schema?

From: Neil Conway <neilc(at)samurai(dot)com>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Can't CREATE INDEX on a schema?
Date: 2003-10-15 18:28:15
Message-ID: 1066242495.28992.971.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 2003-10-15 at 13:54, Marc G. Fournier wrote:
> 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

RTM:

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.

From
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-createindex.html

-Neil

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2003-10-15 18:32:01 Re: Can't CREATE INDEX on a schema?
Previous Message Frank Wiles 2003-10-15 18:19:52 Re: Can't CREATE INDEX on a schema?