Skip to Content
This question has been flagged
postgresqltabletemporary
1 Reply
7061 Views
Avatar
Zbik

Is possible manipulation on postgresql temporary table in odoo?


Presumably, the creation is not a problem, but how to organize views?

I would be grateful for any suggestion or an example.

Avatar
Discard
Avatar
Jaime Vasquez
Best Answer

In posgresql you can use temporary views and or tables but they are not accessible from Odoo.

Odoo has it's special temporary tables, they are  typically used for wizards.  To use a temporary table you can define it as a normal class, just use the following type of inheritance:  models.TransientModel (new api) or osv.osv_memory (old api).

The views are defined as normal views.


see:
http://findnerd.com/list/view/-How-to-create-an-osv-memory-wizard-systems-in-Odoo-9-/12288/

http://stackoverflow.com/questions/28237145/using-popup-window-to-get-user-inputs-and-use-those-inputs-in-buttons-function


HTH

:)

Avatar
Discard
Zbik
Author

Thank you for your answer. I'm not interested in wizard with model Transient. I seek solutions with temporary table and access records per session, not per user.

Related Posts Replies Views Activity
Openerp database list in postgresql Solved
database postgresql table
Avatar
Avatar
Avatar
Avatar
Avatar
5
Apr 23
16321
what postgresql table for Devis? Solved
accounting postgresql table
Avatar
Avatar
1
Nov 16
3187
Postgres Large pg_toast, public.mail_message, pubic.mail_message_message_id.index tables
postgresql size table
Avatar
0
Mar 15
5674
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released
postgresql
Avatar
0
Feb 25
1634
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied
postgresql
Avatar
Avatar
Avatar
2
Jan 25
8283