Using PostgreSQL schemas in Tryton

bell · April 17, 2019, 4:40pm

Hi!
Is it possible to use PostgreSQL schemes in Tryton?
Thanks.

ced · April 17, 2019, 4:49pm

I guess you are talking about schemas.
And yes, Tryton supports them. But they must be defined in the search_path of the PG user and they are not explicitly used in the Model definition. Tryton will uses the first table found in the search_path.

I wrote some times ago a post that explain how to use this feature to share some tables between two databases.

bell · April 17, 2019, 5:17pm

Yes.

Is it possible for a user to choose a schema at the moment of connecting to database?
Is it possible for different users to work with different schemas at the same time?

ced · April 17, 2019, 5:20pm

What users are you talking about? Tryton has only one database user.

bell · April 17, 2019, 5:25pm

I’m talking about Tryton Client users.

ced · April 17, 2019, 5:26pm

The user already choose the database so you can set a search_path per database.

bell · April 17, 2019, 5:36pm

Can the user dynamically set the search_path in Tryton Client?

ced · April 17, 2019, 8:45pm

No, this will be major breakage.