Re: drop tablespace failed when location contains .. on win32

On 9/8/21 6:16 AM, wangsh(dot)fnst(at)fujitsu(dot)com wrote:
> Hi,
>
> I find a problem related to tablespace on win32(server2019).
>
>> postgres=# create tablespace tbs location 'C:\Users\postgres\postgres_install\aa\..\aa';
>> CREATE TABLESPACE
>> postgres=# create table tbl(col int) tablespace tbs;
>> ERROR: could not stat directory "pg_tblspc/16384/PG_15_202109061/12754": Invalid argument
>> postgres=# drop tablespace tbs;
>> WARNING: could not open directory "pg_tblspc/16384/PG_15_202109061": No such file or directory
>> ERROR: could not stat file "pg_tblspc/16384": Invalid argument
> I find that canonicalize_path() only remove the trailing '..', in this case, '..' is not removed , and
> pgsymlink succeed.

That seems like a bug. It's not very canonical :-)

cheers

andrew

--

Andrew Dunstan
EDB: https://www.enterprisedb.com