
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


Wed, 15 Oct 2003 14:54:43 -0300 (ADT)
"Marc G. Fournier" <scrappy@hub.org>
Can't CREATE INDEX on a schema?
On Wed, 15 Oct 2003 14:54:43 -0300 (ADT)
"Marc G. Fournier" <scrappy@hub.org> 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
> 
> 
> ---------------------------(end of
> broadcast)--------------------------- TIP 9: the planner will ignore
> your desire to choose an index scan if your
>       joining column's datatypes do not match
> 

   It works if you leave the period out of the index name.  Not sure
   why it errors, but if you replace the period with an underscore
   it'll create. 

 ---------------------------------
   Frank Wiles <frank@wiles.org>
   http://frank.wiles.org
 ---------------------------------


Wed, 15 Oct 2003 13:19:52 -0500
Frank Wiles <frank@wiles.org>
Re: Can't CREATE INDEX on a schema?
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



Wed, 15 Oct 2003 14:28:15 -0400
Neil Conway <neilc@samurai.com>
Re: Can't CREATE INDEX on a schema?
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


Wed, 15 Oct 2003 14:32:01 -0400
Andrew Dunstan <andrew@dunslane.net>
Re: Can't CREATE INDEX on a schema?