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

Oh, and the bt_index_check just finished without any errors

-----Original Message-----
From: Peter Geoghegan <pg(at)bowt(dot)ie>
Sent: maandag 29 oktober 2018 15:23
To: Paul van der Linden <paul(dot)vanderlinden(at)mapcreator(dot)eu>
Cc: 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

On Mon, Oct 29, 2018 at 2:19 PM Paul van der Linden <paul(dot)vanderlinden(at)mapcreator(dot)eu> wrote:
> Directory is empty (when I check after the error occurred, no idea yet (will test) if there's something there during index creation.

There'll definitely be something during index creation, though the exact directory name will vary per operation.

Do you use temp_tablespaces (easy way to find out is to "show temp_tablespaces")? There's one directory per temp tablespace, so maybe you looked in the wrong one?

> And for some reason I'm not able to set the log_line_prefix in my
> pgAdmin session... ERROR: parameter "log_line_prefix" cannot be
> changed now

That needs to be set in postgresql.conf.

--
Peter Geoghegan