Re: 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
anunderscore  it'll create. 
 
---------------------------------  Frank Wiles <frank@wiles.org>
http://frank.wiles.org---------------------------------