error on index - HELP

Started by molinetalmost 24 years ago3 messagesgeneral

molinet@ibp.u-psud.fr

almost 24 years ago

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.

Mourad EL HADJ MIMOUNE

mimoune@ensma.fr

almost 24 years ago

In reply to: molinet (#1)

MAX TABLE TUPLES and MAX ARRAY SIZE

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.

Neil Conway

neilc@samurai.com

almost 24 years ago

In reply to: Mourad EL HADJ MIMOUNE (#2)

Re: MAX TABLE TUPLES and MAX ARRAY SIZE

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