Re: Can't CREATE INDEX on a schema? - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Can't CREATE INDEX on a schema?
Date
Msg-id 3F8D92A1.5010003@dunslane.net
Whole thread Raw
In response to Can't CREATE INDEX on a schema?  ("Marc G. Fournier" <scrappy@hub.org>)
List pgsql-hackers
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
sameschema as its   parent table.
 
   cheers
   andrew



pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: Can't CREATE INDEX on a schema?
Next
From: Bruce Momjian
Date:
Subject: Re: postgres --help-config