Thread: error on index - HELP

Hello
I want to create an index on geometry point like
create index rtrville on ville using rtree(coord_ville);
I have the following error :
PostgreSQL error message: error: defineindex type point has no default
operator class
Does somebody can help me ?
thanks
MOLINET S.

Hello everyone,

I want know the max number of tuples we can store in one Postgres table and
the max size of one dimension array (ex : INT8 []) we can store in column
value.

Thanks.

Mourad.

On Mon, 10 Jun 2002 18:03:38 +0200
"Mourad EL HADJ MIMOUNE" <mimoune@ensma.fr> wrote:
> I want know the max number of tuples we can store in one Postgres table

http://www.ca.postgresql.org/docs/faq-english.html#4.5

> the max size of one dimension array (ex : INT8 []) we can store in column
> value.

I believe you can store as much as the attribute will hold (which is
1GB compressed in 7.1 and later), but I'm not completely sure.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC