Second question on schemas and INDEX(es) ...

Поиск
Список
Период
Сортировка
Искать
От
Marc G. Fournier
Тема
Second question on schemas and INDEX(es) ...
Дата
Msg-id
20031015165725.E69150@ganymede.hub.org
Список
Дерево обсуждения
Second question on schemas and INDEX(es) ... "Marc G. Fournier" <scrappy@hub.org>
Re: Second question on schemas and INDEX(es) ... Robert Treat <xzilla@users.sourceforge.net>
Re: Second question on schemas and INDEX(es) ... Robert Treat <xzilla@users.sourceforge.net>
Re: Second question on schemas and INDEX(es) ... Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: Second question on schemas and INDEX(es) ... "Marc G. Fournier" <scrappy@postgresql.org>
Re: Second question on schemas and INDEX(es) ... Andrew Dunstan <andrew@dunslane.net>

Okay, after feeling stupid about the last one (altho I hadn't thought to
read the CREATE INDEX page, only the CREATE SCHEMA one), I really hate to
ask this one ... but ... is this documented somewhere also:

CREATE SCHEMA company_00244 CREATE TABLE traffic ( ip_id int4, port int4, bytes bigint, runtime timestamp ) CREATE INDEX traffic_dist ON traffic USING BTREE ( ip_id, port ) CREATE INDEX traffic_time ON traffic USING btree ( hour_trunc(runtime));

ERROR:  parser: parse error at or near "INDEX" at character 122

or, is there an obvious error that I'm just not seeing?

The CREATE SCHEMA page shows CREATE TABLE and CREATE VIEW, so should I
consider CREATE INDEX no supported since it wasn't part of the example?



В списке pgsql-hackers по дате отправления
От: Bruce Momjian
Дата:
Сообщение: Re: postgres --help-config
От: Robert Treat
Дата:
FAQ