Re: org.postgresql.util.PSQLException: ERROR: index row requires more memory than default(8191)

From: msn <pioneer(dot)suri(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: org.postgresql.util.PSQLException: ERROR: index row requires more memory than default(8191)
Date: 2016-04-26 10:35:49
Message-ID: 1461666949861-5900548.post@n5.nabble.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Yes, I am able to resolve the issue which is reported for creating an index.
I create the table with "UNIQUE" for the column like below.
-> create table sample(id serial, info jsonb unique);

So when i tried to insert the data into the table it showing cannot create
the index on the row. So I removed the unique constraint from the info
column. Hence it is resolved.

--
View this message in context: http://postgresql.nabble.com/org-postgresql-util-PSQLException-ERROR-index-row-requires-more-memory-than-default-8191-tp5899379p5900548.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message msn 2016-04-26 11:32:00 Getting the queried result in the form of json structure
Previous Message Venkatesan, Sekhar 2016-04-25 05:47:49 Re: Re: PostgreSQL:ALTER TABLE command hangs forever when DB partitioning is enabled.