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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])