Has anybody encountered the same problem?

[Xu Chu]

ERROR: index row size 8064 exceeds btree maximum, 2713
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text
indexing.
CONTEXT: COPY dict, line 82373: "82373 overindustrialization's"

[Pedram Ghodsnia]

ERROR: index row size 8064 exceeds btree maximum, 2713
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text
indexing.
CONTEXT: COPY dict, line 82373: "82373 overindustrialization's"

Do you receive this error after changing the code or before making any
change?

Pedram

[Xu Chu]

Post by Pedram Ghodsnia

ERROR: index row size 8064 exceeds btree maximum, 2713
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text
indexing.
CONTEXT: COPY dict, line 82373: "82373 overindustrialization's"

Do you receive this error after changing the code or before making any
change?
Pedram

After making changes to the code.
Sometimes, the code works well, however most of the times, it displays
above error messages.
I don't think that's my code's problem.

[Pedram Ghodsnia]

Post by Xu Chu

Post by Pedram Ghodsnia

ERROR: index row size 8064 exceeds btree maximum, 2713
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text
indexing.
CONTEXT: COPY dict, line 82373: "82373 overindustrialization's"

Do you receive this error after changing the code or before making any
change?
Pedram

After making changes to the code.
Sometimes, the code works well, however most of the times, it displays
above error messages.
I don't think that's my code's problem.

If you have never received this error before changing the code, probably
something is wrong in your own code.
Hints:
1- Look at the way you are dealing with the pointers.
2- Whenever you test your code, before running the "create table"
command drop the table first.

Pedram