RE: BUG #15460: Error while creating index or constraint - Mailing list pgsql-bugs

From Paul van der Linden
Subject RE: BUG #15460: Error while creating index or constraint
Date
Msg-id AM0PR0402MB34259A48F54D9B42DECBED79ECF30@AM0PR0402MB3425.eurprd04.prod.outlook.com
Whole thread Raw
In response to Re: BUG #15460: Error while creating index or constraint  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-bugs
Oh, and the bt_index_check just finished without any errors

-----Original Message-----
From: Peter Geoghegan <pg@bowt.ie> 
Sent: maandag 29 oktober 2018 15:23
To: Paul van der Linden <paul.vanderlinden@mapcreator.eu>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>; Heikki Linnakangas <hlinnaka@iki.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.vanderlinden@mapcreator.eu> wrote:
> Directory is empty (when I check after the error occurred, no idea yet (will test) if there's something there during
indexcreation.
 

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

pgsql-bugs by date:

Previous
From: Paul van der Linden
Date:
Subject: RE: BUG #15460: Error while creating index or constraint
Next
From: Peter Geoghegan
Date:
Subject: Re: BUG #15460: Error while creating index or constraint