Workspace doesn't work with PostgreSql

[zak39]

Currently, Workspace is not compatible with PostgreSql.
When I try to create a workspace, I have a few error messages.

The most strange, the Groupfolder's API/REST works to create a groupfolder and enable the advanced permissions.
But, groups for Workspace (GE- and U-) didn't create.

[stefanh12]

Having the same issue

[stanlog]

Hello,
I installed Workspace yesterday on Nextcloud 25.0.7, with Postgresql v13.11 (Debian Bullseye), it seems to work fine. Any news about this issue ?

[zak39]

Hi @stanlog 👋

Did you do anything to the database ?

We have a problem with the constraint with a field in the database.

[stanlog]

Hello @zak39
I didn't anything special on the postgres db tables schemas. I used GroupFolders module alone for a while, all works fine, no problem encounted with the use of Postgresql from the beginning (Nextcloud v25.0.8).

[zak39]

Hello @stanlog

Is it possible to share your PostgreSQL configuration, please ?

I use constraint on foreign keys (

workspace/lib/Migration/Version0000Date20210615125333.php

Lines 95 to 96 in a2061d0

	$table->addForeignKeyConstraint($schema->getTable('group_folders'), ['space_name'], ['mount_point'], ['onDelete' => 'CASCADE', 'onUpdate' => 'CASCADE'], 'fk_gi_sn_work_spaces');
	$table->addForeignKeyConstraint($schema->getTable('group_folders'), ['groupfolder_id'], ['folder_id'], ['onDelete' => 'CASCADE', 'onUpdate' => 'CASCADE'], 'fk_gi_sn_work_spaces');

) and it doesn't work with PostgreSQL.