On Wed, 15 Oct 2003 14:54:43 -0300 (ADT) "Marc G. Fournier" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://frank.wiles.org --------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
