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

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: 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
Date: 2018-10-29 14:23:12
Message-ID: CAH2-WzkVC5=OM3bx=XDYDN_xvr+GXOs+ijgOQ73uA6eb+XDB6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Paul van der Linden 2018-10-29 14:28:31 RE: BUG #15460: Error while creating index or constraint
Previous Message Paul van der Linden 2018-10-29 14:19:37 RE: BUG #15460: Error while creating index or constraint