Re: ALTER DATABASE RESET with unexistent guc doesn't report an error

On Thu, 11 Sept 2025 at 19:27, Álvaro Herrera <alvherre(at)kurilemu(dot)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