Re: BUG #15460: Error while creating index or constraint

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: paul(dot)vanderlinden(at)mapcreator(dot)eu, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Subject: Re: BUG #15460: Error while creating index or constraint
Date: 2018-11-15 01:09:10
Message-ID: CAEepm=2HVHTCXt0eqnxBt5W4uABzTAcCxFexLiMHPd0oNQckFA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Nov 14, 2018 at 9:12 AM Thomas Munro
<thomas(dot)munro(at)enterprisedb(dot)com> wrote:
> On Wed, Nov 14, 2018 at 6:50 AM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> > I think that int64 is the way to go.

Thanks. Pushed to master and 11.

If anyone with a Windows system would like to verify that the problem
is fixed, I found the following test case by changing BufFileSize()
and ltsConcatWorkerTapes() to use int32 instead of off_t so I see the
error too:

create table t as select generate_series(1, 100000000) i, 'hello
world, this is a test' v;
create index on t (i, v);

I expect that test case to fail on Windows before today's commit.

--
Thomas Munro
http://www.enterprisedb.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-11-15 03:24:36 BUG #15507: undefined symbol: geod_polygon_init
Previous Message Tom Lane 2018-11-14 15:18:42 Re: BUG #15506: Foreign data wrapper (postgres_fdw) unexpected behavior