Re: Confusing messages about index row size

2021-09-11 Thread David G. Johnston
On Sunday, September 12, 2021, Jaime Casanova wrote: > > > So, what is it? the index row size could be upto 8191 or cannot be > greater than 2704? > The wording doesn’t change between the two: The size cannot be greater the 8191 regardless of the index type being used. This check is first, proba

Confusing messages about index row size

2021-09-11 Thread Jaime Casanova
Hi everyone, I tried an old test that at some point crashed the database... that is already fixed. So now it gives a good ERROR message: """ postgres=# create table t1 (col1 text, col2 text); CREATE TABLE postgres=# create unique index on t1 ((col1 || col2)); CREATE INDEX postgres=# insert into