Yes I am storing
some “error messages” in data column, and the PK columns are party
of search criteria.
Thanks
Dinesh Pandey
From: Ramakrishnan
Muralidharan [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 02, 2005 4:44
PM
To: [EMAIL PROTECTED];
pgsql-general@postgresql.org;
Hi
It is not advisable to add a variable length data field in the Index key, since
it is very difficult predict the size of the field which may vary from record to
record.
are you included this field for Full text search on data
field?
Regards,
R.
On Thu, Jan 01, 2004 at 03:13:48PM +0530, Dinesh Pandey wrote:
> One of the columns in primary key is of type "TEXT". I am able to insert
> with small data, but for around 3000 characters it's failing. How to handle
> that?
Easy, btree indexes can't handle data with more that 2713 bytes.
You need
Hi,
One of the columns in primary key is of
type “TEXT”. I am able to insert with small data, but for around
3000 characters it’s failing. How to handle that?
Thanks
Dinesh Pandey
From: Ramakrishnan
Muralidharan [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 02, 2005 3:11
Hi,
The issue looks like your Index width exceeds the maximum width
of the index key limit,
Please review the keys used in the index.
Regards,
R.Muralidharan
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On
Behalf Of Din
