Re: [ADMIN] Index row maximum size and crash

2006-07-27 Thread Tom Lane
"Daniel Caune" <[EMAIL PROTECTED]> writes: > I try to create an index on character varying(64) column but PostgreSQL > complains that the index row size reaches the maximum limit: > CREATE INDEX IDX_GSLOG_EVENT_ARCHIVE_GAME_CLIENT_VERSION > ON GSLOG_EVENT_ARCHIVE(GAME_CLIENT_VERSION); > ER

[ADMIN] Index row maximum size and crash

2006-07-27 Thread Daniel Caune
Hi, I try to create an index on character varying(64) column but PostgreSQL complains that the index row size reaches the maximum limit: CREATE INDEX IDX_GSLOG_EVENT_ARCHIVE_GAME_CLIENT_VERSION ON GSLOG_EVENT_ARCHIVE(GAME_CLIENT_VERSION); ERROR: index row requires 198468548 bytes, maximu