Postgresql temporary table

postgresql table temporary

1 Svar

8470 Visninger

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.

Jaime Vasquez

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

Zbik

Forfatter

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.

Kan du lide at diskutere? Læs ikke bare med, deltag aktivt i debatten!

Opret en konto i dag for at få glæde af eksklusive funktioner, og bliv en del af vores skønne fællesskab!

Tilmeld dig

Relaterede indlæg	Besvarelser	Visninger
Openerp database list in postgresql Løst database postgresql table	5 apr. 23	18732
what postgresql table for Devis? Løst accounting postgresql table	1 nov. 16	4674
Postgres Large pg_toast, public.mail_message, pubic.mail_message_message_id.index tables postgresql size table	0 mar. 15	7000
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 feb. 25	3983
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 jan. 25	12113

Dette spørgsmål er blevet anmeldt

Kan du lide at diskutere? Læs ikke bare med, deltag aktivt i debatten!