COPY FROM appears broken in PostgreSQL 15

From: richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: COPY FROM appears broken in PostgreSQL 15
Date: 2023-10-31 21:08:50
Message-ID: CAGA3vBvJx=YX3SCg4D6oct1RNjqW4ToEXe7=V285gqTQc7x0Fg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Did something happen to the COPY FROM command in PostgreSQL 15?

I used to run scripts to process and load data from files into various
PostgreSQL tables. A series of:

copy {schema.table} from '/{path}/{file}' delimiter '|' null '' ;

in PostgreSQL 15 it fails with this message:

ERROR: could not open file "/{path}/{file}" for reading: Permission denied
HINT: COPY FROM instructs the PostgreSQL server process to read a file.
You may want a client-side facility such as psql's \copy.

I have checked and the postgres user can read/write to the file just fine.

In PostgreSQL < 15 it works just fine.
The official PostgreSQL docs, up to and including 16, don't mention a
problem with this command.

Did something happen?

Thanks,
rik.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2023-10-31 21:11:44 Re: COPY FROM appears broken in PostgreSQL 15
Previous Message Evan Rempel 2023-10-31 16:09:20 RPMs changing in the yum repository