Re: Can't CREATE INDEX on a schema?

On Wed, 15 Oct 2003 14:54:43 -0300 (ADT)
"Marc G. Fournier" <scrappy(at)hub(dot)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(at)wiles(dot)org>
http://frank.wiles.org
---------------------------------