Re: Can't CREATE INDEX on a schema? - Mailing list pgsql-hackers

From Neil Conway
Subject Re: Can't CREATE INDEX on a schema?
Date
Msg-id 1066242495.28992.971.camel@tokyo
Whole thread Raw
In response to Can't CREATE INDEX on a schema?  ("Marc G. Fournier" <scrappy@hub.org>)
List 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
thesame schema as       its parent table.       
 
From
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-createindex.html

-Neil




pgsql-hackers by date:

Previous
From: Frank Wiles
Date:
Subject: Re: Can't CREATE INDEX on a schema?
Next
From: Andrew Dunstan
Date:
Subject: Re: Can't CREATE INDEX on a schema?