Re: ALTER DATABASE RESET with unexistent guc doesn't report an error - Mailing list pgsql-hackers

On Thu, 11 Sept 2025 at 19:27, Álvaro Herrera <alvherre@kurilemu.de> wrote:
>
> On 2025-Sep-11, Kirill Reshke wrote:
>
> > I think we can remove "support" for ALTER DATABASE RESET TABLESPACE.
>
> What about ALTER USER RESET TABLESPACE?
>
> --
> Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
> "Computing is too important to be left to men." (Karen Spärck Jones)

Does this feature work?

```
reshke=# alter user u1 set tablespace to tb2;
ERROR:  unrecognized configuration parameter "tablespace"
```

Also this:

```
reshke=# alter table ss reset tablespace ;
ERROR:  syntax error at or near "tablespace"
LINE 1: alter table ss reset tablespace ;
                             ^
```

"tablespace" is tab-completed after 'alter table ss reset <TAB>' which
is a least strange


--
Best regards,
Kirill Reshke