Re: array column and b-tree index allowing only 8191 bytes - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: array column and b-tree index allowing only 8191 bytes
Date
Msg-id 20080612133223.GA5534@alvh.no-ip.org
Whole thread Raw
In response to Re: array column and b-tree index allowing only 8191 bytes  (Celso Pinto <cpinto@yimports.com>)
List pgsql-general
Celso Pinto wrote:

> What, if any, would be the recommended options to improve this
> scenario? Not using intarray? :-)

Not using a broken design.  Arrays are a poor fit in the relational model.
Avoid them.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Adam Dear
Date:
Subject: Re: Unable to dump database using pg_dump
Next
From: Stefan Schwarzer
Date:
Subject: Re: pg_query & $result re-fill