Re: [HACKERS] Can't CREATE INDEX on a schema?

[Andrew Dunstan]

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings